SQL Basics for Data Analysis | Dataford Interview Questions

What is SQL, and how is it used in data analysis?

Use the supplied analysis_data table to demonstrate a basic analytical SQL query. Return category-level summaries using only records with a positive measure, showing how SQL filters and aggregates data.

Output

One row per category with positive measures
Columns: category, record_count, and average_measure
Round average_measure to two decimal places
Order by average_measure descending, then category ascending

Schema

analysis_data

Column	Type	Description
record_idPK	INT	Unique identifier for the analysis record
category	VARCHAR(50)	Category assigned to the record
measure	NUMERIC(10,2)	Numeric value available for analysis

Your question is SQL Basics for Data Analysis. 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

What is SQL, and how is it used in data analysis?

Output

One row per category with positive measures
Columns: category, record_count, and average_measure
Round average_measure to two decimal places
Order by average_measure descending, then category ascending

Schema

analysis_data

Column	Type	Description
record_idPK	INT	Unique identifier for the analysis record
category	VARCHAR(50)	Category assigned to the record
measure	NUMERIC(10,2)	Numeric value available for analysis

Your question is SQL Basics for Data Analysis. 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.