On most SQL engines, you can type JOIN instead of INNER JOIN and it will default to INNER — SELECT title, COUNT(title) as copies_at_store_1 FROM inventory INNER JOIN film ON inventory.film_id = film.film_id WHERE store_id = 1 GROUP BY title ORDER BY title

Get

Explore more quotes

Momchil Kolev