Kursusindhold
Data Manipulation using SQL
Data Manipulation using SQL
1. Database and Nested Queries
2. SQL Joining Tables
Challenge: Decades
Opgave
Swipe to start coding
- 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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 3. Kapitel 4
Challenge: Decades
Opgave
Swipe to start coding
- 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.
Løsning
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående mulighederVar alt klart?
Tak for dine kommentarer!
Sektion 3. Kapitel 4
Skift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder