Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Oppiskele Challenge: Rating of Singers | SQL Tasks
Data Manipulation using SQL

book
Challenge: Rating of Singers

Tehtävä

Swipe to start coding

Create a rating of the singers: from singer with the biggest average Song's price to the smallest one. Output the singer's name (naming) and avearge price (price) of his/her songs.

Ratkaisu

SELECT singers.naming, AVG(songs.price)
FROM singers
INNER JOIN songs
ON songs.singer_id = singers.id
GROUP BY singers.id
ORDER BY AVG(songs.price) DESC

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 3. Luku 3
single

single

SELECT _ _ _
Query ResultQuery Result
No query executed yet...

Kysy tekoälyä

expand

Kysy tekoälyä

ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

some-alt