Give it something to hash

Return each customer's name alongside their order totals, ordered by name then total. Only customers who have orders. Two columns: name and total.

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

⌘⏎