Foundations · drill
The orders nobody priced
Return the ids of every order with no total, in ascending order.
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
⌘⏎