Intermediate SQL Challenge I Goals By the end of this lesson, you will know/be able to: Understand INNER JOINS and OUTER JOINS Understand Aggregate Functions Introduce Subqueries Structure