This page has 0 threads | Add post

Exercises

Many people around the world enjoy and benefit from our exercises. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

You can find other training resources for the subject of this exercise here:

Learn PostgreSQL

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

Software ==>	Postgres SQL (12 exercises)
Topic ==>	Setting criteria using WHERE (6 exercises)
Level ==>	Average difficulty
Subject ==>	PostgreSQL training

Listing out successful albums using the WHERE clause to combine criteria

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

If you don't have a copy of the music_01 database, first follow the instructions at the following link to create it: https://www.wiseowl.co.uk/postgres/exercises/postgres-sql/using-postgres/5350/

Write a query to return rows from the Album table where the album reached a peak position of 1 in the US Billboard 200 chart, and which had sales of at least 10 million, sorting the results in ascending order of Title.

This query should return 25 rows.

Write another query in the same script which shows albums which reached a peak position of number 1 in the chart, or which had sales of at least 10 million.

You should return more results than for the previous query.

Add another query to show gold-certified albums (the RIAA classifies gold-certified albums as those with sales of at least 0.5 million but less than 1 million):

The first of the 105 rows you should see if the list is sorted alphabetically by Title.

Change your last query so that it lists out gold-certified albums which reached number 1 in the chart:

The first few rows you should see (there only are 13).

Add a query to show platinum-certified albums (those with sales of at least 1 million but less than 2 million) which had a peak chart position in the top 10.

The first few of the 73 platinum-certified top 10 albums.

Finally, add a query which shows multi-platinum-certified albums (those with sales of at least 2 million but less than 10 million) which charted outside the top 50.

Despite high sales these 10 albums never made the Billboard top 50.

Save the script as Certified Sales.sql and close it down.

You can find other training resources for the subject of this exercise here:

Learn PostgreSQL

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

This page has 0 threads

Add a new post

EXERCISE TOPIC

POSTGRESQL EXERCISES

POSTGRES SQL EXERCISES

Listing out successful albums using the WHERE clause to combine criteria

Head office

London

Manchester