Incomplete Tickets by Agent

HardGrade 12
📜Adapted from a real exam — IEB November 2021, Paper I, Section A. View the original paper →

Display DomainName, Firstname, Lastname, AgentID, PriorityLevel and DateLogged for every incomplete ticket (DateCompleted is empty), ordered by AgentID ascending then PriorityLevel alphabetically.

Database

Digital Nimbus

A web hosting company tracking domains, hosting packages, service agents and support tickets. Adapted from a real IEB exam.

query.sql

Loading in-browser database…

Run your query to see results here.