Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
547 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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. |
Software: | SQL |
Topic: | Calculations |
Level: | Relatively easy |
Exercise: | Create calculated columns in SQL queries which concatenate multiple values to form longer strings. |
Software: | SQL |
Topic: | Calculations |
Level: | Relatively easy |
Exercise: | List for each event the number of characters in its name. |
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. |
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. |
Software: | SQL |
Topic: | Calculations |
Level: | Relatively easy |
Exercise: | Use the ISNULL function in SQL queries to convert nulls into meaningful values. |
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. |
Software: | SQL |
Topic: | Calculations |
Level: | Average difficulty |
Exercise: | Cast numbers as text to allow you to concatenate them together with strings. |
Software: | SQL |
Topic: | Calculations |
Level: | Average difficulty |
Exercise: | Create calculated columns in SQL Server using the ISNULL function to handle nulls in the data. |
Software: | SQL |
Topic: | Calculations |
Level: | Average difficulty |
Exercise: | Use CASE expressions in SQL queries to categorise a list of venues based on different criteria. |
Software: | SQL |
Topic: | Calculations |
Level: | Average difficulty |
Exercise: | Use IsNull, Coalesce and/or CASE WHEN to replace nulls with values. |
Software: | SQL |
Topic: | Calculations |
Level: | Average difficulty |
Exercise: | Use text functions in SQL queries to clean up messy text data. |
Software: | SQL |
Topic: | Calculations |
Level: | Average difficulty |
Exercise: | Write a CASE WHEN expression to assign countries to different groups. |
Software: | SQL |
Topic: | Calculations |
Level: | Harder than average |
Exercise: | Divide events according to whether their first/last letters are the same or vowels. |
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. |
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. |
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. |
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. |
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!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.