Challenge: Solo Albums
Compito
Swipe to start coding
Find all Solo albums (except those created by Lady Gaga and Michael Jackson) and their average songs prices.
Soluzione
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
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 3. Capitolo 7
single
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... |
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione