SQL: Compare Weekly Store Metrics | Dataford Interview Questions

Write a SQL query to compare weekly donation volume, staffing hours, and sales by store at Mississippi Staffing.

Use the provided store, donation, and weekly operations data. Treat donation volume as the number of donations. Include weeks appearing in either donations or operations data, and represent missing numeric measures as zero.

Output

One row per store and week with at least one recorded measure.
Columns: store_id, store_name, week_start, donation_volume, staffing_hours, and sales_amount.
Order by store_id, then week_start ascending.

Schema

stores

Column	Type	Description
store_idPK	INT	Unique store identifier
store_name	VARCHAR(100)	Mississippi Staffing store name
city	VARCHAR(100)	Store city

donations

Column	Type	Description
donation_idPK	INT	Unique donation identifier
store_id	INT	Store receiving the donation
donated_at	DATE	Donation date
donation_amount	NUMERIC(10,2)	Optional reported donation amount

store_weekly_metrics

Column	Type	Description
store_idPK	INT	Store identifier
week_startPK	DATE	Monday starting the reporting week
staffing_hours	NUMERIC(8,2)	Total staffing hours for the week
sales_amount	NUMERIC(12,2)	Total sales for the week

Your question is SQL: Compare Weekly Store Metrics. 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