SQL for Dataset Manipulation | Dataford Interview Questions

Describe your experience with SQL and how you would use it to manipulate datasets at YipitData.

Using the provided dataset_records table, demonstrate this by summarizing records collected during January 2025. Include only rows with a non-null dataset name.

Output

One row per dataset, with dataset_name, total_records, and average_daily_records.
Include the total and average of record_count for the period.
Order by total_records descending, then dataset_name ascending.

Schema

dataset_records

Column	Type	Description
record_idPK	INT	Unique record identifier
dataset_name	VARCHAR(100)	Name of the tracked dataset
category	VARCHAR(50)	Dataset category
collected_on	DATE	Date on which records were collected
record_count	DECIMAL(12,2)	Number of records collected

Your question is SQL for Dataset Manipulation. Start with the requirements and the one table 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