Provide the SQL for the following data requests. Your SQL should be written as a single script

that can be pasted into MySQL and run without edits.

List the first name, last name, and full address for all students. Sort the results by last name,

first name in ascending order.

Provide a count of faculty by college department ID$.$ Sort the results by count in descending

order.

List employees $($use employeeID$)$ and their years of service. Sort the results by years of

service in descending order.

List staff employees $($use employeelD$)$ who have at least $10$ years of service. Sort the results

by years of service in descending order.

Provide a list of the three biggest classrooms $($not labs$)$ by capacity. Include the building ID$,$

room number, room name, and capacity.

List the section ID$,$ course ID$,$ room ID$,$ and class time for all TTH sections. Sort the results by

class time in ascending order.

Provide a distinct list of students $($use student ID$)$ who have earned a B$,$ or better, in a

section.

List the designator and credits for any Music courses with more than $3$ credits. Hint: The

designator for Music courses begins with MUS.