SQL Dataset Exploration | Dataford Interview Questions

Explore a dataset in PostgreSQL.

Use the provided tables to inspect the data and return a concise summary of the dataset. Focus on counts, missing values, and basic breakdowns that help validate the data.

Output

One row per table or logical grouping requested by the query.
Include the requested summary columns with clear aliases.
Exclude rows that do not meet the stated filters.
Sort the result in a stable, deterministic order.

Schema

dataset_exploration

Column	Type	Description
idPK	INT	Row identifier
table_name	VARCHAR(255)	Logical table name being explored
category	VARCHAR(255)	Optional category label
missing_flag	BOOLEAN	Whether the row is considered missing or incomplete

Your question is SQL Dataset Exploration. 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