Find Common Partner Issue Types | Dataford Interview Questions

Google Operations teams monitor issue reports from partners across products such as Google Ads, YouTube, and Firebase. Write a PostgreSQL query to identify the most common issue type or types for each partner during the 30 days ending on August 30, 2026.

Output

Return one row per partner and issue type tied for the highest report count during the reporting window.
Include partner_name, issue_type_name, and report_count.
Exclude reports with a NULL issue type or an unmatched partner or issue type.
Include reports from August 1, 2026 through August 30, 2026, inclusive.
Sort by partner_name, then descending report_count, then issue_type_name.

Rows with a NULL issue type are excluded because they cannot be classified.

Schema

partners

Column	Type	Description
partner_idPK	INT	Unique partner identifier
partner_name	VARCHAR(100)	Partner or Google product name

issue_types

Column	Type	Description
issue_type_idPK	INT	Unique issue type identifier
issue_type_name	VARCHAR(100)	Human-readable issue classification

partner_issues

Column	Type	Description
issue_idPK	INT	Unique issue report identifier
partner_id	INT	References partners.partner_id
issue_type_id	INT	References issue_types.issue_type_id
occurred_at	TIMESTAMPTZ	Timestamp when the issue was reported
status	VARCHAR(30)	Current issue status

Your question is Find Common Partner Issue Types. Start with the requirements and the three tables in the Question tab.

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

Problem