Challenge: Customer's orders







Step 1



Hint


SELECT … LEFT OUTER JOIN …;

We've created a database for customers and their orders. Not all of the customers have made orders,
however. Come up with a query that lists the name and email of every customer followed by the item
and price of orders they've made. Use a LEFT OUTER JOIN so that a customer is listed even if
made no orders, and don't add any ORDER BY.