From the course: SQL for Non-Programmers
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Challenge: Practice with basic commands - SQL Tutorial
From the course: SQL for Non-Programmers
Challenge: Practice with basic commands
It's your turn now to put your skills to the test. Management has asked us to provide the top 20 orders in the states of Georgia and North Carolina from our sales table. Along with order number, they need order type, customer type, and order total. They are also curious to know how many of the top 20 orders were purchased by individuals, rather than wholesale business orders. Let's break this down into a step-by-step approach. First, query the different customer type options available in the olive oil sales table. What distinct values are available in this column of data? Or in other words, what are the different customer types available? Next, add multiple columns to retrieve the order number, order type, customer type, and order total. Sort this data by largest to smallest order total. Do you see any pattern? What types of orders and customers have the largest order totals? Keeping the same base query, filter for only those orders made in the states of North Carolina and Georgia…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Getting started with SQL5m 33s
-
(Locked)
Retrieving data with SELECT7m 19s
-
(Locked)
Formatting your query5m 40s
-
(Locked)
Putting order to your data with ORDER BY6m 52s
-
(Locked)
Filtering your data with WHERE5m 9s
-
(Locked)
Filtering your data with multiple conditions8m 5s
-
(Locked)
Challenge: Practice with basic commands1m 40s
-
(Locked)
Solution: Basic commands solved4m 9s
-
-
-
-
-