Using CAST() and CONVERT()
In this lesson, you learned that your tables could store data with different types than you want. Sometimes you will need to convert these types to the correct ones to perform the operations you want.
The series
table has a column named num_ratings
that stores integer numbers, but this time it was designed as VARCHAR(5)
. You want to calculate the average of the num_ratings
column, but you think that this column is an integer number.
You prepare the following query:
SELECT AVG(num_ratings)
FROM series
WHERE num_ratings BETWEEN 0 AND 5000
This exercise is part of the course
Cleaning Data in SQL Server Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Use CAST() to convert the num_ratings column
SELECT AVG(___(num_ratings ___ ___))
FROM series
-- Use CAST() to convert the num_ratings column
WHERE ___(___ ___ ___) BETWEEN 0 AND 5000