4. Write a SQL statement to select the user and their emails. Filter on userId. Select the following columns: userId, lastname, firstname, and userEmail

This requires a join.

Paste the SQL below.

5. Write a SQL statement to select the new user and their phone numbers with the phone type. Filter on userId. This requires 2 joins. Select the following columns: userId, lastname, firstname, userPhone and userPhoneType.

Hint: You will need to join 3 tables together.

Paste the SQL below.

6. Create 2 new orders for the user created in question 1 by inserting into the orders and orderItem tables (twice). Place at least 1 item per order.

Create a new order first, then use that orderId to insert into the orderItem table. In total youll need 4 insert statements.

Paste the SQL statement below.