Contenido del Curso
Data Manipulation using SQL
Data Manipulation using SQL
Challenge: Decades
Tarea
- 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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Challenge: Decades
Tarea
- 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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Challenge: Decades
Tarea
- 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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¡Gracias por tus comentarios!
Tarea
- 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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opcionesCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones