Challenge: Solo Albums
Tâche
Swipe to start coding
Find all Solo albums (except those created by Lady Gaga and Michael Jackson) and their average songs prices.
Solution
9
1
2
3
4
5
6
7
8
SELECT albums.title, AVG(price)
FROM songs
INNER JOIN albums
ON songs.album_id = albums.id
INNER JOIN singers
ON songs.singer_id = singers.id
WHERE info = 'Solo' AND NOT singers.naming IN ('Lady Gaga', 'Michael Jackson')
GROUP BY albums.id
Tout était clair ?
Merci pour vos commentaires !
Section 3. Chapitre 7
9
1
2
3
4
5
6
7
8
SELECT albums.title, _ _ _
FROM songs
_ _ _ albums
ON _ _ _
_ _ _ singers
ON _ _ _
WHERE _ _ _
GROUP BY _ _ _
No query executed yet... |
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion