SELECT *
FROM films;
SELECT *
FROM films
WHERE film_id = 1;
SELECT *
FROM films AS f
LEFT JOIN likes AS l ON f.film_id = l.film_id
GROUP BY l.film_id
ORDER BY COUNT(l.film_id) DESC
LIMIT 10;
SELECT *
FROM users;
SELECT *
FROM users
WHERE user_id = 1;
SELECT *
FROM friendship AS f
WHERE f.status_id = 2
LEFT JOIN users AS u ON f.friend_id = u.user_id;
статус дружбы: 1 - неподтверждённая, 2 - подтверждённая
