Challenge: Albums with Two Songs
Congratulations! Now you are ready to create queries in SQL.
We will use the same database with tables songs, singers and albums.
songs
albums
singers
Swipe to start coding
Find the album's ids (id
), titles (title
) and release dates (year
) with number of songs equal to 2. Order these albums from oldest to newest.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Summarize this chapter
Explain the code in file
Explain why file doesn't solve the task
Awesome!
Completion rate improved to 5.88
Challenge: Albums with Two Songs
Swipe to show menu
Congratulations! Now you are ready to create queries in SQL.
We will use the same database with tables songs, singers and albums.
songs
albums
singers
Swipe to start coding
Find the album's ids (id
), titles (title
) and release dates (year
) with number of songs equal to 2. Order these albums from oldest to newest.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 5.88single