The following are the goals for Chapter 7.
1. Describe the pieces of advanced SQL
2. Write single and multiple table queries using advanced SQL
3. Describe the various types of join commands