Proposed AI prompt: authored for this guide, not executed or evaluated. Draft DuckDB SQL for an already-loaded view named orders. Schema only (no real customer rows): order_id INTEGER; order_date DATE; category VARCHAR; status VARCHAR; amount DECIMAL(12,2). Each row is one order. Amount is the full order amount in one currency. Allowed statuses in this exercise: paid, cancelled, pending. Question: for paid orders dated October 1 through October 31, 2026, return category, COUNT(*) AS paid_rows, SUM(amount) AS paid_total. Use an inclusive start and exclusive November 1 end; sort by category. No joins, file access, network calls, extensions, writes, or execution. Return one SELECT over orders, explain every filter, and name assumptions about missing values, duplicates, currency, refunds and order grain. If those assumptions are unknown, ask instead of inventing them. A human will inspect the draft and check a fictional example before use. These instructions are not a security boundary or an execution sandbox.