Ordering by likes
The marketing team loved your organized film list! So much so, they've recommended you to their peers for another project.
This new project is about analyzing the catalog to see which films are the most highly rated on IMDb, with the highest score at the top so they can quickly decide which titles to highlight or promote. The results will display film IDs, which the team can plug into their own systems.
To ćwiczenie jest częścią kursu
Intermediate SQL Querying with AI
Instrukcje do ćwiczenia
- Write a prompt to show film ids with their IMDb score, sorted by highest score first.
Interaktywne ćwiczenie praktyczne
Spróbuj tego ćwiczenia, uzupełniając ten przykładowy kod.
SELECT *
FROM reviews;