Question

Complete the query below so that all products are returned and only those that match in the orders table.

select p.product_id, count(o.order_id) as items_sold from products as p ___________ orders as o on p.product_id = o.product_id
group by p.product_id;

Question options:

	Left Outer Join
	Inner Join
	Cross Join
	Right Outer Join

Answer 1

Answer: Left Outer Join

select p.product_id, count(o.order_id) as items_sold from products as p Left Outer Join orders as o on p.product_id = o.product_id group by p.product_id;