Exercise

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.

Instructions 1/3

undefined XP
  • 1

    Get all details for all clients with a marital status listed as "married".

  • 2

    Get the number of clients that don't have a personal loan.

  • 3

    Get all details for all clients with credit in default.