Cinema: Любители высоких оценок
Hard
Войдите, чтобы сохранялся прогресс.
Найдите пользователей, которые поставили оценку 4 или 5 как минимум 3 разным фильмам Ожидаемые колонки: viewer_id, high_rated_movies
Структура таблиц
PRAGMA foreign_keys = ON;
CREATE TABLE viewers (id INTEGER PRIMARY KEY, username TEXT NOT NULL, country TEXT NOT NULL, joined_at TEXT NOT NULL);
CREATE TABLE movies (id INTEGER PRIMARY KEY, title TEXT NOT NULL, genre TEXT NOT NULL, release_year INTEGER NOT NULL);
CREATE TABLE views (id INTEGER PRIMARY KEY, viewer_id INTEGER NOT NULL, movie_id INTEGER NOT NULL, watched_at TEXT NOT NULL, minutes_watched INTEGER NOT NULL,
FOREIGN KEY(viewer_id) REFERENCES viewers(id), FOREIGN KEY(movie_id) REFERENCES movies(id));
CREATE TABLE ratings (viewer_id INTEGER NOT NULL, movie_id INTEGER NOT NULL, rating INTEGER NOT NULL,
PRIMARY KEY(viewer_id, movie_id), FOREIGN KEY(viewer_id) REFERENCES viewers(id), FOREIGN KEY(movie_id) REFERENCES movies(id));
Пример данных
movies
| id | title | genre | release_year |
|---|---|---|---|
| 1 | Skyline | Sci-Fi | 2020 |
| 2 | City Lights | Drama | 2019 |
| 3 | Fast Lane | Action | 2021 |
| 4 | Deep Sea | Documentary | 2018 |
| 5 | Laugh Out | Comedy | 2022 |
Показано строк: 5 (LIMIT 5)
ratings
| viewer_id | movie_id | rating |
|---|---|---|
| 1 | 2 | 2 |
| 2 | 3 | 3 |
| 3 | 4 | 4 |
| 4 | 5 | 5 |
| 5 | 6 | 1 |
Показано строк: 5 (LIMIT 5)
viewers
| id | username | country | joined_at |
|---|---|---|---|
| 1 | user_1 | DE | 2025-12-02 |
| 2 | user_2 | FR | 2025-12-03 |
| 3 | user_3 | PL | 2025-12-04 |
| 4 | user_4 | IT | 2025-12-05 |
| 5 | user_5 | NL | 2025-12-06 |
Показано строк: 5 (LIMIT 5)
views
| id | viewer_id | movie_id | watched_at | minutes_watched |
|---|---|---|---|---|
| 1 | 2 | 2 | 2026-01-02 11:00:00 | 30 |
| 2 | 3 | 3 | 2026-01-03 12:00:00 | 40 |
| 3 | 4 | 4 | 2026-01-04 13:00:00 | 50 |
| 4 | 5 | 5 | 2026-01-05 14:00:00 | 60 |
| 5 | 6 | 6 | 2026-01-06 15:00:00 | 70 |
Показано строк: 5 (LIMIT 5)
Ваш SQL
Результат
Результат пуст (0 строк).