Microsoft SQL training exercises | Calculations

Showing exercises 1-7 (out of 7)

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

Go to exercise ...

Category: SQL
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 ...

Category: SQL
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 ...

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

Go to exercise ...

Category: SQL
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 ...

Category: SQL
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 ...

Category: SQL
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 ...

This page has 0 threads Add post