Why This Role and SQL Basics | Dataford Interview Questions

Tell me why you want this Data Analyst role at The Home Depot, and walk me through a couple of basic SQL questions.

Use the tables below to answer the SQL portion.

Output

Return one row per department.
Columns: department_name, active_associate_count, open_order_count, open_order_rate.
Include only departments with at least one active associate.
Sort by open_order_rate descending, then department_name ascending.

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

associates

Column	Type	Description
associate_idPK	INT	Unique associate identifier
department_id	INT	Department the associate belongs to
associate_name	VARCHAR(100)	Associate name
is_active	BOOLEAN	Whether the associate is currently active

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
department_id	INT	Department associated with the order
order_status	VARCHAR(20)	Order status such as open, closed, or canceled
order_amount	DECIMAL(10,2)	Order amount, may be null for incomplete records

Your question is Why This Role and SQL Basics. 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.