Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines:

• You must submit at least 5 SELECT Statements.
• Each statement must select data from more than one table.
• Each table should be selected from by at least one statement.
• You must use at least one aggregate function (e.g. sum, count, max, avg, etc.).
• Each statement should have a WHERE clause.
• Each statement should have an ORDER BY clause.
• When selecting data from multiple tables, do not use "old-style joins" with the tables delimited in the FROM clause. Use the JOIN clause instead.

Submit your SQL SELECT Statements as one text file, with a .sql extension.