Advertisers in Both Weeks | Dataford Interview Questions

SQL: find advertisers who submitted in both weeks.

Asked in the Tech round stage. Only the question heading is visible; the rest is points-walled.

Write a SQL query using the provided tables. Treat week 1 as 2024-05-06 through 2024-05-12 and week 2 as 2024-05-13 through 2024-05-19.

Output

One row per advertiser that submitted during both weeks.
Return advertiser_id, advertiser_name, week_1_submissions, and week_2_submissions.
Sort by advertiser_id ascending.

advertisers

Column	Type	Description
advertiser_idPK	INT	Unique advertiser identifier
advertiser_name	VARCHAR(150)	Advertiser display name

submissions

Column	Type	Description
submission_idPK	INT	Unique submission identifier
advertiser_id	INT	Advertiser associated with the submission
submitted_at	TIMESTAMP	Timestamp when the submission was made

Your question is Advertisers in Both Weeks. 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.