Group By in SQL | Dataford Interview Questions

Write a SQL query using GROUP BY to transform data as described in the prompt.

Use the supplied teams and work_logs tables. Include all teams and only work logs from 2025-01-01 through 2025-03-31.

Output

One row per team, including teams without qualifying work logs
Columns: team_name, log_count, total_hours, completed_hours, and open_hours
Treat missing hour totals as zero
Sort by team_name ascending

teams

Column	Type	Description
team_idPK	INT	Unique team identifier
team_name	VARCHAR(100)	Team name

work_logs

Your question is Group By in SQL. 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.

Write a SQL query using GROUP BY to transform data as described in the prompt.

Use the supplied teams and work_logs tables. Include all teams and only work logs from 2025-01-01 through 2025-03-31.

One row per team, including teams without qualifying work logs
Columns: team_name, log_count, total_hours, completed_hours, and open_hours
Treat missing hour totals as zero
Sort by team_name ascending

teams

Column	Type	Description
team_idPK	INT	Unique team identifier
team_name	VARCHAR(100)	Team name

work_logs

Your question is Group By in SQL. 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.