Get startedGet started for free

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 ratings table: information about chocolate bars: the origin of the beans, percentage of cocoa and the rating of each bar.
  • The voters table: 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.

This exercise is part of the course

Functions for Manipulating Data in SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample 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 > ___;
Edit and Run Code