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 |