Interview Guides Experiences

Interview Guides

All questions/SQL & Data Manipulation

Top Accounts by Support Ticket Volume

Medium

JoinsGroup ByAggregations

Problem

Task

You are given support ticket data and account metadata. Write a PostgreSQL query that returns the top 10 accounts by support ticket volume in the last 90 days, ranked from highest to lowest ticket count. Use the ticket creation date to define the 90-day window.

Problem

Task

You are given support ticket data and account metadata. Write a PostgreSQL query that returns the top 10 accounts by support ticket volume in the last 90 days, ranked from highest to lowest ticket count. Use the ticket creation date to define the 90-day window.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Monthly Ticket Volume TrendsEasy Monthly Ticket Volume by TeamEasy

Revolut

Top Users by Recent Transaction VolumeMedium

Top Accounts by Support Ticket Volume | Dataford Interview Questions