SQL Query with Filtering and Sorting | Dataford Interview Questions

Select all records from a table where a field is greater than a specified value, and sort the result set in ascending order.

Asked in the OA stage. First SQL question on the online assessment.

Output

Return record_id, record_name, and metric_value for records where metric_value is greater than 50.
Return one row per qualifying record, sorted by metric_value ascending, then record_id ascending to break ties.

records

Column	Type	Description
record_idPK	INT	Unique record identifier
record_name	VARCHAR(100)	Record name
metric_value	INT	Numeric field used for filtering and sorting

Your question is SQL Query with Filtering and Sorting. 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.

Select all records from a table where a field is greater than a specified value, and sort the result set in ascending order.

Asked in the OA stage. First SQL question on the online assessment.

Return record_id, record_name, and metric_value for records where metric_value is greater than 50.
Return one row per qualifying record, sorted by metric_value ascending, then record_id ascending to break ties.

records

Column	Type	Description
record_idPK	INT	Unique record identifier
record_name	VARCHAR(100)	Record name
metric_value	INT	Numeric field used for filtering and sorting

Your question is SQL Query with Filtering and Sorting. 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.