User 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

Exclude any tickets that have "Account Access" as the issue_type and only return records for users who have more than 1 support ticket of another type. Finally, sort the records by users with the most support tickets at the top.