Keep rows without a match: LEFT JOIN · exercise 1 of 1 · free preview
LEFT JOIN keeps every row of the left table. Where nothing matches, the right side is empty (NULL).
Show every customer's last name and how many orders they placed. Customers without orders show 0.
Tables in this practice shop
customersproductsordersorder_items