Data type precedence
In this exercise, you will evaluate the rating information from the ratings
table and you will see what happens when a decimal value is compared to an integer.
Remember: in SQL Server, data is implicitly converted behind the scenes from one type to another, in such a way that no data loss occurs.
This exercise is part of the course
Functions for Manipulating Data in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
bean_type,
rating
FROM ratings
WHERE ___;