Skip to main content
In this first lesson, we’ll cover the Filter, Columns, Group By and Sort tools. These are foundational tools that every person working with data will use very frequently.

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

​
Solution