You can apply where conditions to your query to filter on one or several fields.
As where conditions can become complex, they will be introduced in this and some of the following lessons. We start with the table tbl_customers that has the following structure:
customer_id (number), first_name (string), last_name (string)
To filter on a number, you often use the following comparison operators:
< (less than)
<= (less than or equal)
> (greater than)
<= (greater or equal)
Start playing around by changing the conditions in the right window. Try to output only datasets with customer_id > 20.