SQL Data Retrieval and Validation | Dataford Interview Questions

Can you write SQL queries to retrieve specific data from a database and validate the results?

Use the validation_results table. Retrieve failed validations with at least one recorded defect. Exclude rows with a missing defect count and return the results in reverse execution order.

Output

One row per matching validation, with validation_id, test_name, executed_on, and defect_count
Include only failed validations with defect_count greater than zero
Order by executed_on descending, then validation_id ascending

Schema

validation_results

Column	Type	Description
validation_idPK	INT	Unique validation result identifier
test_name	VARCHAR(100)	Name of the validation test
result_status	VARCHAR(20)	Validation outcome
severity	VARCHAR(20)	Severity assigned to the validation result
executed_on	DATE	Date when the validation ran
defect_count	INT	Number of defects identified by the validation

Your question is SQL Data Retrieval and Validation. 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