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!

CALCULATIONS exercises

This page lists the 9 exercises about Calculations in Postgres SQL on our website:

Software:	Postgres SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Add and sort by a column to show unsold tickets for shows.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Casting and converting to show the correct average ticket price for each tour.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Create calculated columns joining names and minutes/seconds together.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Use the CASE expression to calculate the correct certifications for albums based on sales.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Use the COALESCE function to get meaningful names where they are null.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Use CASE expressions to categorise venues by capacity, era and stattus.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Use trimming and replacing to clear up messy names for album tracks.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Work out the average length of songs in a list of albums using calculations and casting.

Show this exercise

Software:	Postgres SQL
Topic:	Calculations
Level:	Harder than average
Exercise:	Extract information from addresses and list of venue names using text functions.

Show this exercise

You can search our full list of PostgreSQL exercises here. Or why not learn to do them the right way on one of our PostgreSQL training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post

EXERCISE TOPIC

POSTGRESQL EXERCISES

POSTGRES SQL EXERCISES

CALCULATIONS exercises

Head office

London

Manchester