kljensen · January 23, 2018 16:35
diff --git a/qq18.sql b/qq18.sql
 SELECT
    movies.title,
    COUNT(*) as num_reviews
 FROM
    movies
 JOIN
    reviews
        ON  movies.id = reviews.movie_id
 WHERE
    action = 1
 GROUP BY
    movies.id
 ORDER BY
    num_reviews DESC LIMIT 10;
	SELECT
	movies.title,
	COUNT(*) as num_reviews
	FROM
	movies
	JOIN
	reviews
	ON movies.id = reviews.movie_id
	WHERE
	action = 1
	GROUP BY
	movies.id
	ORDER BY
	num_reviews DESC LIMIT 10;