This lesson's interactive features are locked, please to keep using them

Query Practice – Support Tickets

CashPal stores customer support requests in a support_tickets table. A recent bug caused a flood of "Account Access" tickets, hiding other important issues. Now that the bug is fixed, Support wants to focus on users with multiple non-"Account Access" problems.

Assignment

Write an SQL statement that includes an INNER JOIN and returns the following:

The user's name
The user's username
The count of support tickets attributed to that user, labeled as support_ticket_count

With the constraints:

Exclude any tickets that have "Account Access" as the issue_type.
Return records only for users who have more than 1 non-"Account Access" support ticket.
Sort the records so that users with the most support tickets appear first.