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:

Courses in 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

Use the LIKE operator and wildcard characters in the WHERE clause of a SQL query to return a list of live music venues.

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 Venue table where the name of the venue begins with A and ends with Z.

You should find a single matching venue.

Add another query in the same script which returns venues whose address contains Manchester, but where the address doesn't contain United States (let's be parochial about this):

The 7 venues in Manchester in the UK.

Sticking with the transatlantic theme, write a new query which shows venues whose name contains the word theatre. Some venues spell this word correctly as theatre, others spell it incorrectly as theater. Make sure that your query returns venues which contain either spelling.

The first few of the 72 venues this query should list.

We don't really care about amphitheatres (or amphitheaters if you prefer). Modify the query to exclude any amphitheatre or amphitheater venues.

List of theatres which aren't amphitheatres

You should be down to 32 venues now.

Add one more query which returns venues whose venue or other_names column contains either Coca-Cola or Pepsi.

The list of venues (it probably wasn't worth including Irn Bru in the list of drinks to search for).

Save the script as I_like queries.sql and then close it down.

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

Courses in 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

Use the LIKE operator and wildcard characters in the WHERE clause of a SQL query to return a list of live music venues.

Head office

London

Manchester