Skip to main content
Your first real challenge! This is where you’ll learn to use your skills to solve a real-world problem. In the challenge, we want you to help us find out how much money we made in each our market segments. We only want to look at 1) orders in 1995, 2) ordered orders (in the O_ORDERSTATUS column) and 3) where customers are in Europe. You should try to solve this challenge with as few tools as possible. You will most likely use Columns, Filters, Group By, Combine, New Column and IF Column. You should use the ORDERS, CUSTOMERS, NATION and REGIONS tables. We did it with 20 tools, but we’re pretty sure you can do it with less. This is the result you should get (55 rows x 3 columns):
If you’re a really cool and intelligent person, you could even get to this result (11 rows x 6 columns - hint: Pivot)

​
Solution