1> In the example below, assign the employee_id column the alias of “Number.” Complete the SQL statement to order the result set by the employee_id.
SELECT employee_id, first_name, last_name
FROM employee
2> Create a query that will return all the DJs on Demand CD titles ordered by year with titles in alphabetical order by year.
3> Order the DJs on Demand songs by descending title. Use the alias “Our Collection” for the song title.
4> Write a SQL statement using the ORDER BY clause that could retrieve the information needed. Do not run the query. Create a list of students who are in their first year of school. Include the first name, last name, student ID number, and parking place number. Sort the results alphabetically by student last name and then by first name. If more than one student has the same last name, sort each first name in Z to A order. All other results should be in alphabetical order (A to Z).