SQL exercises on CALCULATIONS

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

Software: SQL
Version: Any version of SQL Server
Topic: Calculations
Level: Relatively easy
Course: Introduction to SQL
Exercise: List for each event the number of characters in its name.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Calculations
Level: Average difficulty
Course: Introduction to SQL
Exercise: Cast numbers as text to allow you to concatenate them together with strings.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Calculations
Level: Average difficulty
Course: Introduction to SQL
Exercise: Use IsNull, Coalesce and/or CASE WHEN to replace nulls with values.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Calculations
Level: Average difficulty
Course: Introduction to SQL
Exercise: Write a CASE WHEN expression to assign countries to different groups.

Go to exercise ...

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

Go to exercise ...

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

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Calculations
Level: Harder than average
Course: Introduction to SQL
Exercise: Divide events according to whether their first/last letters are the same or vowels.

Go to exercise ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post