CIS336: Lab 6: Group Functions and Subqueries
Scenario and Summary
Lab 6 will introduce the concept of group functions and subqueries to meet more complex report requirements. This lab may be completed using either DeVry’s Omnymbus EDUPE-APP lab environment, or a local copy of the MySQL database running on your own computer using the ACME database tables. The lab will utilize a set of tables that are created and populated by the script file (create_ACME_db.sql).