MulaiMulai sekarang secara gratis

Movies and ratings with correlated queries

Report a list of movies that received the most attention on the movie platform, (i.e. report all movies with more than 5 ratings and all movies with an average rating higher than 8).

Latihan ini adalah bagian dari kursus

Data-Driven Decision Making in SQL

Lihat Kursus

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

SELECT *
FROM ___
WHERE ___ -- Select all movies with more than 5 ratings
	(SELECT ___
	FROM ___
	WHERE ___);
Edit dan Jalankan Kode