Kursusindhold
Practice SQL with Cinema Database
Practice SQL with Cinema Database
The Best Genre
Opgave
Swipe to start coding
You have to return two records:
- first one contains the most popular genre according to the sales
- second one contains the best genre according to the rating
To evaluate these metrics, use total sales and average rating respectively. Name the column genre.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 2. Kapitel 5
The Best Genre
Opgave
Swipe to start coding
You have to return two records:
- first one contains the most popular genre according to the sales
- second one contains the best genre according to the rating
To evaluate these metrics, use total sales and average rating respectively. Name the column genre.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 2. Kapitel 5
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder