SQL Query with Filtering and Sorting

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

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