Type CASTs
In the video, you saw that type casts are a possible solution for data type issues. If you know that a certain column stores numbers as text, you can cast the column to a numeric form, i.e. to integer.
SELECT CAST(some_column AS integer)
FROM table;
Now, the some_column column is temporarily represented as integer instead of text, meaning that you can perform numeric calculations on the column.
This exercise is part of the course
Introduction to Relational Databases in SQL
Exercise instructions
- Execute the given sample code.
- As it doesn't work, add an
integertype cast at the right place and execute it again.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Calculate the net amount as amount + fee
SELECT transaction_date, amount + fee AS net_amount
FROM transactions;