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.
Latihan ini adalah bagian dari kursus
Functions for Manipulating Data in SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
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 > ___;