Left Join to Find Missing Reviews
Easy
joins
Airbnb
LinkedIn
Stripe
Write a query using a LEFT JOIN to list all products and their review ratings. Products without reviews should show NULL for the rating. Return product_name and rating, ordered by product_name.
Expected Output: All products with their ratings (NULL if no review exists).
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...