Task list

7.1.1 Week 4 Monday:

  • (QUIZ) The first 5 minutes of class is scheduled for a quiz of writing two SQL queries.

  • GROUP BY and HAVING: Read Text Pages 82-86, slides 4-13 ( ChapterTwoLecture-Part2.pdf)

  • Do queries on slides 4-13

7.1.2 Week 4 Wednesday:

  • Query two or more tables by subquery: Read text pages 87-90, slides 73-80

  • Do queries on slides 73-80

7.1.3 Practice Homework:

Text Pages 87-88 Review Questions

Note from the book: Use Both the Inventory and Warehouse tables to answer the following Review Questions:

2.40 through 2.43

2.44

2.45 and 2.46

2.47 and 2.48

2.50

2.51 and 2.52