CIS336 iLab Week 6

$12.50

CIS336 iLab Week 6
Lab 6 will introduce group or aggregate functions and subqueries. Make sure to follow the instructions provided…

SKU: CIS336 iLab Week 6 Categories: , Tags: , , , ,

Description

CIS336 iLab Week 6

CIS336 iLab Week 6

A+

Group Functions and Subqueries

Lab 6 will introduce group or aggregate functions and subqueries. Make sure to follow the instructions provided by each step.

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.

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.

(Instructions)

(Database Script)

Follow the instructions to complete the lab by downloading the following files.

Be sure to refer to the ERD for the database in…when creating your queries.