Conditional statements part 3 Conditions are booleans. Boolean is a data type with two possible values:  TRUE or  FALSE. For example 10 > 100 - FALSE 10 > 5 - TRUE 10 > 5 AND 100 < 5 - FALSE Boolean columns have only two values - either 1 or 0.  TRUE indicates 1 and  FALSE indicates 0 We can replace columns such as employed or unemployed to  1 or  0 to make it easier to filter data. To filter data using booleans we will use the  IS TRUE or  IS NOT TRUE keywords. SELECT * FROM table1 WHERE col1 IS NOT FALSE AND col2 IS TRUE