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.