Handling Missing Data | Dataford Interview Questions

How would you handle missing data in a dataset?

Write a SQL query that returns every sales record while replacing missing product names and regions with Unknown Product and Unknown. Replace missing quantities and prices with 0 for reporting purposes.

Output

One row per sales record with columns sale_id, product_name, region, quantity, and unit_price
Include all records, with no remaining NULL values in the output columns
Order results by sale_id ascending

Schema

sales_records

Column	Type	Description
sale_idPK	INT	Unique identifier for the sales record
product_name	VARCHAR(100)	Name of the purchased product
region	VARCHAR(50)	Sales region
quantity	INT	Number of units sold
unit_price	NUMERIC(10,2)	Price per unit

Your question is Handling Missing Data. 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

How would you handle missing data in a dataset?

Output

One row per sales record with columns sale_id, product_name, region, quantity, and unit_price
Include all records, with no remaining NULL values in the output columns
Order results by sale_id ascending

Schema

sales_records

Column	Type	Description
sale_idPK	INT	Unique identifier for the sales record
product_name	VARCHAR(100)	Name of the purchased product
region	VARCHAR(50)	Sales region
quantity	INT	Number of units sold
unit_price	NUMERIC(10,2)	Price per unit

Your question is Handling Missing Data. 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.