From the course: SQL for Non-Programmers

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Solution: Basic commands solved

Solution: Basic commands solved - SQL Tutorial

From the course: SQL for Non-Programmers

Start my 1-month free trial Buy for my team

Solution: Basic commands solved

“

So how did you do? When you successfully complete this challenge, share it on LinkedIn with hashtag SQLWithChristina. You were tasked with preparing a report of the top 20 sales orders in the states of North Carolina and Georgia. It is supposed to include order number, order type, customer type, and order total. They also requested an additional report with the same information, but only considering individual customers. In order to prepare your final report, you were first challenge with uncovering the different customer types available in our sales table. Your query should look like this. SELECT DISTINCT customer type FROM oliveoil.sales. If we execute the query, we can answer the question, what customer types are available? There are two, business and individual. Be careful here. If you forgot to include the distinct keyword before customer type, then your output will be a long list of rows of business or individual, each repeating because it is returning every row of the table…

Contents