SQL Joins in Scenarios | Dataford Interview Questions

How would you approach scenario-based SQL questions involving joins?

Use the provided properties and edge_requests tables. Return metrics for successful requests from January 1 through January 7, 2025, while retaining properties with no qualifying requests.

Output

One row per property, including properties with no qualifying requests.
Columns: property_id, property_name, successful_request_count, and total_bytes.
Treat missing totals as zero and order by property_id ascending.

Schema

properties

Column	Type	Description
property_idPK	INT	Unique property identifier
property_name	VARCHAR(100)	Property display name
region	VARCHAR(20)	Property operating region
is_active	BOOLEAN	Whether the property is active

edge_requests

Column	Type	Description
request_idPK	INT	Unique request identifier
property_id	INT	Referenced property identifier
occurred_at	TIMESTAMP	Request timestamp
status_code	INT	HTTP response status code
bytes_sent	BIGINT	Response bytes sent

Your question is SQL Joins in Scenarios. 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