Course Content

Data Manipulation using SQL

1. Database and Nested Queries

Database SQL In Statement Challenge In Statement SQL Exists Statement

2. SQL Joining Tables

SQL Inner Join SQL Joins SQL Left & Right Join SQL Full Outer Join SQL Union

3. SQL Tasks

Challenge: Albums with Two Songs Challenge: the Biggest Album Challenge: Rating of Singers Challenge: Decades Challenge: Two Singers Challenge: Solo vs Bands Challenge: Solo Albums Challenge: Singers Stats

Challenge: Decades

Task

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.

Task

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 below

Everything was clear?

Section 3. Chapter 4

Challenge: Decades

Task

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.

Task

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 below

Everything was clear?

Section 3. Chapter 4

Challenge: Decades

Task

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.

Task

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 below

Everything was clear?

Task

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 below

Section 3. Chapter 4

Switch to desktop for real-world practiceContinue from where you are using one of the options below