CIS 336 STUDY Career Path Begins/cis336study.com CIS 336 STUDY Career Path Begins/cis336study.com | Page 86

Question 7.
(TCO 8) Before the COMMIT command
is used, you can retrieve deleted records by using the _____
command.
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.
A few IMPORTANT things to note if using EDUPE MySQL: