Database Testing - SQL - Order by clause

Order By Clause:

18. List out the employee id, last name in ascending order based on the employee id.

Select employee_id, last_name from employee order by employee_id

19. List out the employee id, name in descending order based on salary column

Select employee_id, last_name, salary from employee order by salary desc

20. list out the employee details according to their last_name in ascending order and salaries in descending order

Select employee_id, last_name, salary from employee order by last_name, salary desc

21. list out the employee details according to their last_name in ascending order and then on department_id in descending order.

Select employee_id, last_name, salary from employee order by last_name, department_id desc