CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Seite 84

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;
Select unit_price as Retail_Price from items;
Select unit_price as RetailPrice from items;
**Any calculated fields MUST be given an alias (and note above NO
SPACES in alias). For example: