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.
Questo esercizio fa parte del corso
Introduction to Relational Databases in SQL
Istruzioni dell'esercizio
- Execute the given sample code.
- As it doesn't work, add an
integertype cast at the right place and execute it again.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
-- Calculate the net amount as amount + fee
SELECT transaction_date, amount + fee AS net_amount
FROM transactions;