Assuming the simple database with one table holding student names, departments and gpa, write the SQL to

1extract all the fields of all the records in the database and put them in order by name

2. put them in order by gpa, highest to lowest

3.put them in order by gpa, highest to lowest, only listing the top 3

4. put them in order by department

5extract a list of the departments cited in the database

6extract the name and gpa information for all students in the 'music' department

7extract and calculate the number of students and the average gpa for each department, ordered by average gpa, highest to lowest

8extract and calculate the number of students and the average gpa for each deparment with more than 2 students, ordered by average gpa, highest to lowest