Exercise

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.

Instructions

100 XP

Select year_qtr, total_sales, percent_ecom, and finally percent_change_year_ecom from spectrumdb.ecommerce_sales.
Find where percent_change_year_ecom is greater than 50 as a string.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise