Everyone who is not signed up

Return the names of every customer who is not signed up to the newsletter — including the ones who never answered. Order by name.

Tables in this database · Shop

CREATE TABLE customers (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  city TEXT NOT NULL,
  signed_up DATE NOT NULL,
  newsletter BOOLEAN
)

CREATE TABLE orders (
  id INTEGER PRIMARY KEY,
  customer_id INTEGER NOT NULL,
  placed_on DATE NOT NULL,
  total NUMERIC(10,2),
  shipped BOOLEAN
)

CREATE TABLE products (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  price NUMERIC(10,2) NOT NULL,
  discontinued BOOLEAN NOT NULL
)

Your query

⌘⏎