> ## Documentation Index
> Fetch the complete documentation index at: https://docs.less.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Test: Where's the Money

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):

<Frame>
  <img src="https://mintcdn.com/less-51/7vxLoN8O_CeWSGG4/images/academy/beginner/challenge1.png?fit=max&auto=format&n=7vxLoN8O_CeWSGG4&q=85&s=33aba640530a934522e3683fd3484ed3" width="3438" height="1168" data-path="images/academy/beginner/challenge1.png" />
</Frame>

If you're a really cool and intelligent person, you could even get to this result (11 rows x 6 columns - hint: [Pivot](/tools/reshape/pivot))

<Frame>
  <img src="https://mintcdn.com/less-51/7vxLoN8O_CeWSGG4/images/academy/beginner/challenge2.png?fit=max&auto=format&n=7vxLoN8O_CeWSGG4&q=85&s=0aa0a514c7a34daeb6b8dfcda012ec3a" width="3438" height="680" data-path="images/academy/beginner/challenge2.png" />
</Frame>

## Solution

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/xWTuRwYTYcWsM8v4WGRtM9ubjvO6gJDFN01WJk1r2c6g?metadata-video-title=Challenge+-+Where%27s+the+Money&video-title=Challenge+-+Where%27s+the+Money&accent-color=%232b8761&poster=https://less-docs.s3.eu-central-1.amazonaws.com/ChallengeWheresTheMoney.png" allow="accelerometer; gyroscope; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>
