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

book
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

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 ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

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

Demandez à l'IA

expand
ChatGPT

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

We use cookies to make your experience better!
some-alt