Challenge: Solo vs Bands
Tâche
Swipe to start coding
Explore which songs are more expensive: created by Solo singers or by Bands (info
column of singers
table)?
Solution
9
1
2
3
4
5
6
7
SELECT info, AVG(price)
FROM songs
INNER JOIN singers
ON singers.id = songs.singer_id
INNER JOIN albums
ON albums.id = songs.album_id
GROUP BY info
Tout était clair ?
Merci pour vos commentaires !
Section 3. Chapitre 6
single
9
1
2
3
4
SELECT _ _ _
FROM _ _ _
_ _ _
GROUP BY _ _ _
No query executed yet... |
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion