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. Make sure you use the proper notation

for your comments $($see the practice solution for an example of the format$).$ There will be a $5\%$

deduction for scripts that cannot be pasted into MySQL and run without edits.

List the ID $($use person ID$)$ and age for each student. Sort the results by age in descending

order.

Provide a distinct list of faculty $($use faculty ID$)$ who teach MWF$.$ Sort the results by faculty

ID in ascending order.

Provide a count of students by student type.

List the capacity of the largest classroom in each building $($use building ID$).$ Sort the results

by capacity in descending order.

Provide a list of classrooms $($use classroom ID$)$ that have an overhead and computer, or a

whiteboard.

Provide a list of staff $($use staff ID$)$ who are skilled at programming.

List the first name, last name, and full address for all employees who are also students. Sort

the results by last name, first name in ascending order.

List the designator, course name, and description for all freshman$-$level $(100-199)$ courses.

Sort the results by designator in ascending order.