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:

PostgreSQL classes

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

Various queries listing albums combining null with other 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 the following fields from the Album table for albums which didn't appear in the US Billboard 200 chart (that is, albums whose US_Billboard_200_peak position is NULL), sorting the albums alphabetically by title:

The first few of the 24 albums not appearing in the top 200 chart.

Write a query in the same script to show albums which appeared in any position the US Billboard 200 chart but which didn't appear in the US Billboard 200 year end chart.

Each of the 328 listed albums has a value for the peak chart position but no value for the year end chart position.

Write another query to return albums which had a peak chart position of 1 but which didn't appear in the year end chart.

Good to see Tay-Tay at the top of the list.

Finally, write another query to return albums which reached number 1 in the weekly chart but which were outside the top 10 in the year end chart. Remember that you can use round brackets to control the order in which your conditions are evaluated.

Your list should include albums which don't have a position in the year end chart, as well as those which do (but it's outside the top 10).

Save the script as All about the nulls.sql and close it down.

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

PostgreSQL classes

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

Various queries listing albums combining null with other criteria

Head office

London

Manchester