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 training 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 ==>	Relatively easy
Subject ==>	PostgreSQL training

Display various list of albums depending on the text in the album name

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 columns from the Album table where the album title is Greatest Hits, sorted in chronological release date order:

You'd think artists would be a little more creative in naming their work!

Write another query in the same script which shows albums with titles which contain greatest hits (use the ilike rather than the like operator so that you don't have to worry about upper or lower case):

Greatest Hits can appear anywhere within the album title.

Write a new query in the same script which selects rows from the Tour table where the tour name ends with the word Tour, sorted so that the tour with most shows appears first:

The word Tour should only appear at the end of the tour name.

Add a new query to the same script which selects tours where the tour name does not include the word Tour:

The full set of results you should see.

Save the script as Tracks of my tours.sql and then close it.

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

Display various list of albums depending on the text in the album name

Head office

London

Manchester