Exercise

Manipulating numeric data

In this exercise, you are going to use some common SQL Server functions to manipulate numeric data.

You are going to use the ratings table, which stores information about each company that has been rated, their different cocoa beans and the rating per bean.

You are going to find out information like the highest, lowest, average score received by each company (using functions like MAX(), MIN(), AVG()). Then, you will use some rounding functions to present this data with fewer decimals (ROUND(), CEILING(), FLOOR()).

Instructions 1/3

XP

1
2
3

Select the number of cocoa flavors the company was rated on.
Select the lowest, highest and the average rating that each company received.

Take Hint (-10 XP)