Aggregate Functions

Project Description:

Part II is 40% of the total grade of the project. You must use MySQL to implement the database you designed in Part I. Test the queries you used to create and populate the database in MySQL. After successful completion of an SQL query:

• Type your name at the following mysql> prompt.
• Take a screen shot (Alt + Print Screen) that includes the query, the confirmation message, the results (if any), and your name.
• Paste the screen shot in the appropriate location in your MS Word file.

IMPORTANT NOTICE: If some of the tables in your database have the same names as the tables in the databases used in class (Premiere Products, Henry Books, and Alexamara Marina Group), re-name your tables. For instance, if the name of your table is CUSTOMER, change it to CUSTOMER_1. Do not delete existing tables from the databases used in class otherwise you will not be able to complete the rest of the homeworks.

Part II must include:

Paste all screen shots from parts a-d for each table together in one place.

1. A query that is based on two tables and includes both an arithmetic and a special operator in the conditional expression.
2. A query that is based on more than two tables and includes both an arithmetic and a special operator in the conditional expression. Both the arithmetic and the special operator must be different from the ones used in part a.
3. A query that includes a sub-query.
4. A query that contains the GROUP BY clause, one of the aggregate functions, the WHERE statement, and the HAVING operator.
5. Two additional complex queries designed by you that are different from the above. A complex query is based on two or more tables and includes either several conditions or a subquery (or both).