QueryingTheDatabase

  • Due Mar 20, 2016 at 11:59pm
  • Points 45
  • Questions 45
  • Time Limit None

Instructions

This quiz will cover querying the database.  Please pay close attention to each statement.  Quiz extended until Next Thursday.

Questions 1-10 uses the following BOOK_INFORMATION table:

Column Names
Book_ID
Book_Title
Price

 

Questions 11-15 uses the following SALES table:

Column Names
Store_ID
Sales_Date
Sales Amount

 

Questions 16-25 uses the following table EXAM_RESULTS:

Student_ID First_Name Last_Name Exam_ID Exam_Score
10 Laura Lynch 1 90
10 Laura Lynch 2 85
11 Grace Brown 1 78
11 Grace Brown 2 72
12 Jay Jackson 1 95
12 Jay Jackson 2 92
12 William Bishop 1 70
13 William Bishop 2 100
14 Charles Prada 2 85
Only registered, enrolled users can take graded quizzes