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.
Это упражнение является частью курса
Functions for Manipulating Data in SQL Server
Интерактивное практическое упражнение
Попробуйте выполнить это упражнение, дополнив этот пример кода.
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 > ___;