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

# Mind Your Language

Syntax is a quite powerful way to reduce the amount of tools you need to use to get to your result. You can read much more about it in the [Syntax](/canvas/syntax-quickstart) section.

In this lesson, we'll dive into the different types of syntaxes and how to use them.

<Frame>
  <iframe className="w-full aspect-video" src="https://player.mux.com/HVuA02WxTbZiK4E5u5zGflmWuXIC01A57FrSyhaKXMFgY?metadata-video-title=Tools+-+Mind+Your+Language&video-title=Tools+-+Mind+Your+Language&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 *Example\_Dataset* dataset and you want to get the result shown below. Our result contains five rows and we used three tools to get the result.

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

You are supposed to only use a single New Column tool to add the *syntaxing* column. Here's logic of how we create it.

1. Think of this in steps. You can perhaps start by creating each step with an individual New Column tool and then consolidate them at the end
2. We using a conditional statement syntax to create the *syntaxing* column.
3. We specify that the *date\_string* should be a datetime value. Then we add the number of days in the *int\_col* column to it.
4. If it is larger than todays date (our date is Oct 6, 2025), then we multiply the *simple\_int* column with the nulls\_col if it is not null and one if it is null (maybe COALESCE?).
   If it is not larger than todays date, then we create a NULL value

## Solution

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