CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 95
Question 8.
(TCO 8)Based on the contents of the
BOOK_ORDER table shown below, which of the following
SQL statements will list the order number and customer number
for the most recent orders in the system?
==============================================
CIS336 iLab 6 Group Functions and Subqueries
FOR MORE CLASSES VISIT
www.cis336study.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.