PubMatic Reseller vs Direct Counts | Dataford Interview Questions

PubMatic QA engineers need to validate seller entries discovered on a publisher web page. Write a PostgreSQL query that counts the exact PubMatic direct and PubMatic reseller entries for the page with domain dailynews.example.

Requirements

Join web_pages to page_entries using page_id.
Return one row containing the page domain, the count of exact PubMatic direct entries, and the count of exact PubMatic reseller entries.
Preserve the page in the result even if it has no matching entries, and do not count NULL or other entry types.

Schema

web_pages

Column	Type	Description
page_idPK	INT	Primary key for the web page
domain	VARCHAR(255)	Web page domain

page_entries

Column	Type	Description
entry_idPK	INT	Primary key for the discovered entry
page_id	INT	Referenced web page identifier
entry_type	VARCHAR(50)	Classified seller entry type

Your question is PubMatic Reseller vs Direct Counts. Start with the requirements and the two 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