Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Impara Challenge: Solo Albums | SQL Tasks
Data Manipulation using SQL

book
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

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?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 3. Capitolo 7
single

single

SELECT albums.title, _ _ _
FROM songs
_ _ _ albums
ON _ _ _
_ _ _ singers
ON _ _ _
WHERE _ _ _
GROUP BY _ _ _
Query ResultQuery Result
No query executed yet...

Chieda ad AI

expand

Chieda ad AI

ChatGPT

Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione

some-alt