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.