Working with different types of data
The examples in this course are based on a data set about chocolate ratings (one of the most commonly consumed candies in the world).
This data set contains
- The
ratingstable: information about chocolate bars: the origin of the beans, percentage of cocoa and the rating of each bar. - The
voterstable: details about the people who participate in the voting process. It contains personal information of a voter: first and last name, email address, gender, country, the first time they voted and the total number of votes.
In this exercise, you will take a look at different types of data.
Cet exercice fait partie du cours
Functions for Manipulating Data in SQL Server
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT
company,
company_location,
bean_origin,
cocoa_percent,
rating
FROM ratings
-- Location should be Belgium and the rating should exceed 3.5
WHERE company_location = ___
AND rating > ___;