Simple SQL Count Query | Dataford Interview Questions

Your question is Simple SQL Count Query. Start with the requirements and the three tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

IBM Support wants a product-level view of support demand across IBM watsonx and related offerings. Write a PostgreSQL query that counts qualifying support tickets for every product, including products with no qualifying tickets.

Requirements

Return every product and the number of support tickets created during Q1 2025, from January 1 through March 31.
Count only tickets associated with accounts whose account_tier is Enterprise.
Include products with zero qualifying tickets and order results by ticket count descending, then product name ascending.

Representative Sample Data

Schema

ibm_products

Column	Type	Description
product_idPK	INT	IBM product identifier
product_name	VARCHAR(100)	IBM product name

support_accounts

Column	Type	Description
account_idPK	INT	Customer account identifier
account_name	VARCHAR(100)	Customer account name
account_tier	VARCHAR(30)	Customer account classification

support_tickets

Column	Type	Description
ticket_idPK	INT	Support ticket identifier
product_id	INT	Referenced IBM product
account_id	INT	Referenced support account
created_at	DATE	Ticket creation date
status	VARCHAR(30)	Current ticket status
priority	VARCHAR(20)	Ticket priority