From the course: SQL for Non-Programmers
Join today to access over 23,200 courses taught by industry experts.
Challenge: Practice with multiple table joins - SQL Tutorial
From the course: SQL for Non-Programmers
Challenge: Practice with multiple table joins
Our help is required once more. The management team at Two Trees Olive Oil has some questions about sales at a regional level. We can use our newfound knowledge of SQL joins to answer them. Management would like to know total sales for only the product category olive oil split by region. Which region has sold the most? Which region has sold the least? Additionally, they would like to see this same report of total sales by region for olive oil, but only considering their business customers. How can we retrieve this data? Hint, you'll need to join the sales table on the regions table. Once you have your answers ready, take a moment to review how I solve the request. Good luck!
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.