> ## 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.

# Less to do More

In this first lesson, we'll cover the [Filter](/tools/basics/filter), [Columns](/tools/basics/columns), [Group By](/tools/reshape/group-by) and [Sort](/tools/basics/sort) tools.

These are foundational tools that every person working with data will use very frequently.

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/HVuA02WxTbZiK4E5u5zGflmWuXIC01A57FrSyhaKXMFgY?metadata-video-title=Tools+-+Less+to+do+More&video-title=Tools+-+Less+to+do+More&autoplay=1&muted=1&accent-color=%232b8761" allow="accelerometer; gyroscope; autoplay; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>

## Exercise

We're working with the *ORDERS* dataset. We only want orders that are currrently ordered (*O* in the *O\_ORDERSTATUS* column) and the task is to get the result shown below. We ended up with 5 rows and used five tools to get the result.

*orders* is a count of the transactions and *volume* is a sum of the *O\_TOTALPRICE* column.

<Frame>
  <img src="https://mintcdn.com/less-51/7vxLoN8O_CeWSGG4/images/academy/beginner/1result.png?fit=max&auto=format&n=7vxLoN8O_CeWSGG4&q=85&s=b3ff76a60543c6d85ff953b04cda04aa" width="3004" height="394" data-path="images/academy/beginner/1result.png" />
</Frame>

## Solution

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/DApcI5ty1K786FZD6DjZ01GffSUCu00I84VYKypgI4Eug?metadata-video-title=Solution+-+Less+to+do+More&video-title=Solution+-+Less+to+do+More&accent-color=%232b8761&&poster=https://less-docs.s3.eu-central-1.amazonaws.com/SolutionLessToDoMore.png" allow="accelerometer; gyroscope; encrypted-media; picture-in-picture;" allowfullscreen="true" />
</Frame>