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.
Este exercício faz parte do curso
Functions for Manipulating Data in SQL Server
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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 > ___;