PostgreSQL SERIAL and REFERENCES #49

Hard 40 pts New · no attempts yet sql

Topics

Toolliyo edge

PostgreSQL: PostgreSQL SERIAL and REFERENCES #49

Static hints

Use WITH for CTEs, OVER() for windows

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

CREATE TABLE orders (
  id SERIAL PRIMARY KEY,
  customer_id INT NOT NULL REFERENCES customers(id),
  amount NUMERIC(12,2) NOT NULL CHECK (amount >= 0),
  created_at TIMESTAMPTZ DEFAULT NOW()
);

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

PostgreSQL: CTEs, window functions, ILIKE, JSONB @>, EXPLAIN ANALYZE.

Prev Next All problems

PostgreSQL SERIAL and REFERENCES #49

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion