Simple filtering of text

Remember, the WHERE clause can also be used to filter text results, such as names, days of the week, education level,...

For example, this query gets the details of all campaigns that the bank ran in May:

SELECT *
FROM campaigns
WHERE month = 'may';

Now it's your turn to practice using WHERE with text values!

Important: in PostgreSQL (the version of SQL we're using), you must use single quotes with WHERE.

Exercise