Your question is PubMatic Reseller vs Direct Counts. Start with the requirements and the two 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.
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.
web_pages to page_entries using page_id.PubMatic direct entries, and the count of exact PubMatic reseller entries.| Column | Type | Description |
|---|---|---|
| page_idPK | INT | Primary key for the web page |
| domain | VARCHAR(255) | Web page domain |
| 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 |