Choose the query to display names of the department in the college ordered in department_name in ascending order.select department_name from Department order by department_name asc;select department_name from Department order by name asc;select name from Department order by name;None of the listed optionsReview Answer

SELECT nameFROM instructorWHERE dept name = ’Physics’ORDER BY name;By default, the order by clause lists items in ______ order.AnyAscendingSameDescending

Write a query to display the coursename of the courses having the coursefees above average fees of all the courses. Display the records sorted in ascending order based on coursename.Note:1. Display only the coursename of the courses having the coursefees above average fees of all the courses.2. Order by is mandatory.Sample Output:

Write a query to display the staff_name, subject_name and subject_code details from staff and subject table. Display all the staff_name even if they have not handling any subjects. Display the records sorted in ascending order based on staff_name.Note:1. Display only the staff_name, subject_name and subject_code details from staff and subject table.2. Display all the staff_name even if they have not handling any subjects.3. Use joins. Tables involved are subject and staff4. Order by is mandatory.Sample Output:

Write a MySQL statement to sort the students in descending order of the last name

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? SELECT * FROM Persons SORT BY 'FirstName' DESC SELECT * FROM Persons ORDER BY FirstName DESC SELECT * FROM Persons SORT 'FirstName' DESC SELECT * FROM Persons ORDER FirstName DESC