.equella.ecollege.com/file/1f23e4c7-a182-4f52-bc25-6092065bf68b/22/CIS336_W6_iLab.html”>iLab> STEP 1: Download
the Week 6 Lab Instructions and Answer Sheet
Lab 6 of 7: Group
Functions and Subqueries
.readspeaker.com/cgi-bin/rsent?customerid=6598&lang=en_us&readid=container&url=” title=”Listen to this page using ReadSpeaker”>Listen
Lab 6 will introduce group or aggregate
functions and subqueries. Make sure to follow the instructions provided by each
Submit your assignment to the Dropbox, located
at the top of this page. For instructions on how to use the Dropbox, read these .equella.ecollege.com/file/8ff9f27a-3772-48cf-9855-4bec4e6706bf/1/Dropbox.html”>step-by-step instructions.
(See the Syllabus
section “Due Dates for Assignments & Exams” for due dates.)
The deliverable for this lab will include the
The Student Answer Sheet file that you will
download below provides a place for each query and the output of the query. You
will copy and paste this information from your MySQL environment. Be sure your
name, course number, and lab number are in your file which will be submitted to
the iLab Dropbox for Week 5.
Microsoft Office: Word
Use a personal copy or access the software at .devry.edu/”>https://lab.devry.edu.
Access the software at .devry.edu/”>https://devry.edupe.net:8300
PRELIMINARY STEP: If
You Have Not Created the Database Yet, Please Complete.
This lab will utilize the tables that were
created in Lab 4. If you have not yet created these tables, you can create the
database and tables (used in labs 4–7) by downloading the following files.
STEP 1: Download the
Week 6 Lab Instructions and Answer Sheet
Follow the instructions to complete the lab by
downloading the following files.
Be sure to refer to the ERD for the database
in .equella.ecollege.com/items/184903ef-b6c7-433c-89e6-d48b5ad6f3be/0/OM_ERD.docx”>OM_ERD.docx when
creating your queries.
STEP 2: Submit Your
Complete the answer sheet to show your queries
and results, and submit according to the lab instructions.
This is the end of Lab