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

book
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

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 ?

Comment pouvons-nous l'améliorer ?

Merci pour vos commentaires !

Section 3. Chapitre 6
single

single

SELECT _ _ _
FROM _ _ _
_ _ _
GROUP BY _ _ _
Query ResultQuery Result
No query executed yet...

Demandez à l'IA

expand

Demandez à l'IA

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