Your question is SQL Sorting and Ordering. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
How would you write a SQL query to sort an employee table by salary in ascending order?
Use the employees table and return every employee. Salaries that are missing should appear after employees with recorded salaries.
employee_id, employee_name, and salaryemployee_id ascending for ties| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| salary | NUMERIC(10,2) | Annual employee salary |