Contenu du cours
Data Manipulation using SQL
Data Manipulation using SQL
1. Database and Nested Queries
2. SQL Joining Tables
Challenge: Rating of Singers
Tâche
Swipe to start coding
Create a rating of the singers: from singer with the biggest average Song's price to the smallest one. Output the singer's name (naming
) and avearge price (price
) of his/her songs.
Solution
Tout était clair ?
Merci pour vos commentaires !
Section 3. Chapitre 3
Challenge: Rating of Singers
Tâche
Swipe to start coding
Create a rating of the singers: from singer with the biggest average Song's price to the smallest one. Output the singer's name (naming
) and avearge price (price
) of his/her songs.
Solution
Tout était clair ?
Merci pour vos commentaires !
Section 3. Chapitre 3