Untitled

We will work up to the primary table we want. Lets start with something a little bit less complex first. When working on these, keep in mind there are many ways to write equivalent SELECT statements, so your solution may be different from the one given.

Names and Email Table

See if you can re-create the following table with a SELECT statement:

• See Answer

Now we can start working with the data in the other tables.

GitHub Table

See if you can re-create the following table with a SELECT statement:

• See Answer

Now, we can start trying to join some information together across table.

Courses Table

Next, lets see if we can create a list of courses and who teaches them. It is easier to start by just counting the number of people that teach each course:

• See Answer

Now, we can move to the full table:

• See Answer