This is the end of Lab 5 . ---------------------------------------------------------------------------------
CIS 336 iLab 6 Group Functions and Subqueries
For more course tutorials visit www . uophelp . com
CIS336 : Lab 6 : Group Functions and Subqueries LAB OVERVIEW 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 ‘ sOmnymbus EDUPE-APP lab environment , or a local copy of the MySQL database running on your own computer using the OM database tables . The lab will utilize a set of tables that are represented by the ERD ( OM _ ERD . docx ) and are created and populated by the script file ( create _ OM _ db . sql ). Follow the instructions in the file CreateOMTables . docx to create your database , tables , and data .
A few IMPORTANT things to note if using EDUPE MySQL : ** There can be NO SPACES in alias names given to a column . For example : Select unit _ price as ― Retail Price ― from items ; – this does NOT work in EDUPE MySQL . Any of the following WILL WORK : Select unit _ price as ― RetailPrice ‖ from items ; Select unit _ price as ― Retail _ Price ‖ from items ;