CALCULATIONS exercises

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

Software:	SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Add basic expressions to an SQL query to calculate new values from existing columns in a table.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Create calculated columns in SQL queries which concatenate multiple values to form longer strings.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	List for each event the number of characters in its name.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Use the CAST and CONVERT functions in SQL queries to control the data types of calculated columns.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Use the IIF function and CASE expression to create calculated columns in a SQL query based on a list of music albums.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Relatively easy
Exercise:	Use the ISNULL function in SQL queries to convert nulls into meaningful values.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Add calculated columns to a SQL query to work out the average length of songs in a list of albums.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Cast numbers as text to allow you to concatenate them together with strings.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Create calculated columns in SQL Server using the ISNULL function to handle nulls in the data.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Use CASE expressions in SQL queries to categorise a list of venues based on different criteria.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Use IsNull, Coalesce and/or CASE WHEN to replace nulls with values.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Use text functions in SQL queries to clean up messy text data.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Average difficulty
Exercise:	Write a CASE WHEN expression to assign countries to different groups.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Harder than average
Exercise:	Divide events according to whether their first/last letters are the same or vowels.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Harder than average
Exercise:	Use a variety of text functions in SQL queries to manipulate names and addresses of a list of venues.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Harder than average
Exercise:	Use CASE expressions in SQL queries to categorise a list of concerts by ticket sales and cancellations.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Harder than average
Exercise:	Use the % modulus operator and a lot of ingenuity to show how big each country is relative to Wales.

Show this exercise

Software:	SQL
Topic:	Calculations
Level:	Harder than average
Exercise:	Use the CHARINDEX function multiple times to show the number of characters between two words in a text string.

Show this exercise

You can search our full list of SQL exercises here. Or why not learn to do them the right way on one of our SQL 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