Workshop

The Workshop provides quiz questions to help solidify your understanding of the material covered, as well as exercises to provide you with experience in using what you have learned. Try to answer the quiz and exercise questions before checking the answers in Appendix A, “Answers.”

Quiz

1:In the section “Nesting Subqueries,” the sample subquery returned several values: 
LE SHOPPE
BIKE SPEC
LE SHOPPE
BIKE SPEC
JACKS BIKE

Some of these are duplicates. Why aren't these duplicates in the final result set?

2:Are the following statements true or false?

  1. The aggregate functions SUM, COUNT, MIN, MAX, and AVG all return multiple values.

  2. The maximum number of subqueries that can be nested is two.

  3. Correlated subqueries are completely self-contained. ...

Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial