In this section, you will learn how to filter data in SQL. Previously, you learned how to filter data in Sheets. Filtering data is to look at only a subset of rows, based on some column condition. For example, if you have a database containing information for all citizens of the USA, a filter could be applied to look only at residents of Texas. You have already seen how to apply filters in Sheets.
Filtering data in SQL is as simple as using the
WHERE keyword. You can
WHERE column_condition to any SQL query, and the result will be
filtered only to rows that satisfy the column condition. For example, you might
want to look only at bike trips which are at least one hour (3600 seconds).
It is also possible to filter by multiple criteria. For example to look at bike
trips which are 60 minutes or more and the
query would be as below.