Active US Customers — AND, OR, NOT in SQL

The problem

Brightlane's marketing team is launching a domestic renewal campaign and needs the current active US customer base as the audience list.

Write a query to return the name and email of every active customer registered in the United States.

Assumptions:

The customers table contains every customer Brightlane has on file.
US customers are identified by country = 'US'.
Active customers are identified by is_active = true; deactivated customers have is_active = false.

Output:

One row per active US customer, with columns name and email.

Schema · ecommerce 5 tables

categories

id integer

name text

parent_id? integer

products

id integer

name text

category_id integer

price numeric

stock_qty integer

attributes? jsonb

order_items

id integer

order_id integer

product_id integer

quantity integer

unit_price numeric

customers

id integer

name text

email text

city? text

country text

created_at timestamptz

is_active boolean

orders

id integer

customer_id integer

ordered_at timestamptz

status text

total_amount numeric

Check answerShift Ctrl ↵

Run previews · Check grades

Write a query, then run it to see results here.

Worked solution Try it yourself first

Solution query

SELECT
  name,
  email
FROM
  customers
WHERE
  country = 'US'
  AND is_active = TRUE

The shape

Two equality checks joined by AND — each row reaches the result only when both the country and the active flag match what the renewal campaign needs.

Clause by clause

SELECT name, email names the two columns the audience list needs. The customers table has plenty of other columns; only these two come back.
FROM customers reads the customer table. There's no join here — every column referenced in the filter and the output lives on this one table.
WHERE country = 'US' AND is_active = true is the compound condition. country = 'US' keeps US rows; is_active = true keeps active rows. The AND requires both to be true on the same row, so a US customer who is inactive is dropped, and a UK customer who is active is also dropped. Only rows that satisfy both conditions reach SELECT.

Why `AND` and not two separate conditions

There's no way to write "both of these must hold" without AND. Listing the two comparisons separated by a comma, or stacking two WHERE clauses, is a syntax error. AND is the operator that joins two booleans into a single boolean, and WHERE accepts exactly one boolean expression.

You practiced combining two conditions with AND so a row passes only when both are true. AND is the everyday shape of a multi-criteria filter — the recurring choice when an audience must satisfy every requirement at once.

Return the name and email of every active customer registered in the United States

The shape

Clause by clause

Why `AND` and not two separate conditions

Reading explains SQL. Writing it, over and over with instant feedback, is what makes you fluent.

The shape

Clause by clause

Why AND and not two separate conditions

Reading explains SQL. Writing it, over and over with instant feedback, is what makes you fluent.

Why `AND` and not two separate conditions