365 Days of Daily Coding: Day 52

Today went by pretty fast. I think that means I had a good day although I did not do much of the things I would have wanted. I have got to work tomorrow which is a killer.

I solved an easy challenge today.

SELECT title FROM(
SELECT f.title, COUNT(i.inventory_id) AS counts
FROM film f LEFT JOIN inventory i
ON f.film_id = i.film_id
GROUP BY f.film_id) AS l
WHERE counts > 7
ORDER BY title;