Only the busy cities

Return each city with more than five shipped orders, and that count, busiest first then by city. Call the count shipped_orders.

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

⌘⏎