Welcome to the third week of SQL Fundamentals MOOC. In lesson 3, you will learn to write SQL queries to do the following:

Create and restrict groups of data using group functions

Retrieve data from multiple tables using joins

Solve queries using subqueries

Please watch each video carefully to ensure that you get the information you need to complete this lesson. The videos and tutorials are listed sequentially, and we recommend that you use the instructional materials in that order. At the end of the lesson, don’t forget to take the quiz.