SELECT *
FROM users
WHERE user_id IN (SELECT friend_id
FROM user_friends
WHERE user_id = 228
AND confirmed = 1);

SELECT *
FROM users
WHERE user_id IN (SELECT user_id
FROM film_likes
WHERE film_id = 777);

SELECT g.name
FROM genres g
INNER JOIN film_genres fg ON fg.genre_id = g.genre_id
INNER JOIN films f ON f.film_id = fg.film_id
WHERE f.film_id = 228;

SELECT f.name
COUNT(fl.user_id) AS likes
FROM films f
INNER JOIN film_likes fl ON f.film_id = fl.film_id
GROUP BY f.name
ORDER BY likes
LIMIT 10;