Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære Challenge: the Biggest Album | SQL Tasks
Data Manipulation using SQL

book
Challenge: the Biggest Album

Oppgave

Swipe to start coding

Find the album's title (title) with a maximum number of songs (count ids). If there are multiple answers, select the first one from sorted in the lexicographical order.

Løsning

SELECT albums.title, COUNT(songs.id)
FROM albums
INNER JOIN songs
ON songs.album_id = albums.id
GROUP BY albums.id
ORDER BY count(songs.id) DESC, albums.title
LIMIT 1

Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 3. Kapittel 2
single

single

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

Spør AI

expand

Spør AI

ChatGPT

Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår

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