Course Content
Data Manipulation using SQL
Data Manipulation using SQL
1. Database and Nested Queries
2. SQL Joining Tables
Challenge: Decades
Task
Swipe to show code editor
- Group songs into decades. Your result should record in such a format: Decade, songs.id, songs.title, songs.price. For example:
1970 5 Time 200
1970 4 Stairway to Heaven 510
1980 16 Billie Jean 1200
And so on for all the songs.
For songs from one decade, sort them, starting from the most expensive.
- Change your query to not include albums with the undefined decade.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 3. Chapter 4
Challenge: Decades
Task
Swipe to show code editor
- Group songs into decades. Your result should record in such a format: Decade, songs.id, songs.title, songs.price. For example:
1970 5 Time 200
1970 4 Stairway to Heaven 510
1980 16 Billie Jean 1200
And so on for all the songs.
For songs from one decade, sort them, starting from the most expensive.
- Change your query to not include albums with the undefined decade.
Switch to desktop for real-world practiceContinue from where you are using one of the options belowEverything was clear?
Thanks for your feedback!
Section 3. Chapter 4
Switch to desktop for real-world practiceContinue from where you are using one of the options below