Session Ready
Exercise

CASTing data

It happens often to need data in a certain type or format and to find that it's stored differently. For example:

  • Integrating data from multiple sources, having different data types, into a single one
  • Abstract data should be more readable (i.e. True/False instead of 1/0) Luckily, you don't need to make any changes in the data itself. You can use functions for explicitly converting to the data type you need (using CAST() and CONVERT()).

You are now going to explicitly convert data using the CAST() function. Remember the syntax:

CAST(expression AS data_type [(length)])
Instructions 1/3
undefined XP
  • 1

    Write a query that will show a message like the following, for each voter: Carol Rai was born in 1989.

    • 2

      Divide the total votes by 5.5. Transform the result to an integer.

    • 3

      Select the voters whose total number of votes starts with 5.