Experimenting with compatible types
As we covered in the slides, some data types are compatible with others, meaning they will implicitly convert to the proper type when used in an assignment or comparison clause. For example, if you compare an INTEGER and a VARCHAR, it will convert the INTEGER into a VARCHAR for the comparison.
Deze oefening maakt deel uit van de cursus
Introduction to Redshift
Oefeninstructies
- Select
year_qtr,total_sales,percent_ecom, and finallypercent_change_year_ecomfromspectrumdb.ecommerce_sales. - Find where
percent_change_year_ecomis greater than 50 as a string.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Select year_qtr, total_sales, percent_ecom, percent_change_year_ecom
SELECT year_qtr,
___,
percent_ecom,
___
FROM spectrumdb.ecommerce_sales
-- Find where percent_change_year_ecom is greater than 50
WHERE ___ > ___;