SQL Query for Table Data | Dataford Interview Questions

Write a SQL query to fetch data from a specific table.

For this exercise, retrieve Sagitec Solutions QA test cases that are ready for execution. Return only the requested columns and sort the results by priority, then by test case ID.

Output

One row per ready test case.
Columns: test_case_id, test_case_name, module, priority_level, and execution_status.
Include only rows with execution_status equal to Ready.
Sort by priority_level descending, then test_case_id ascending.

Schema

qa_test_cases

Column	Type	Description
test_case_idPK	INT	Unique identifier for the QA test case
test_case_name	VARCHAR(150)	Name of the test case
module	VARCHAR(80)	Sagitec Solutions product module under test
priority_level	INT	Numeric priority, where a higher value indicates greater urgency
execution_status	VARCHAR(30)	Current execution status of the test case

Your question is SQL Query for Table 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