pub const CREATE: &str = "-- A self-made query that covers two-phase stateful simple aggregation.\n--\n-- Show the minimum final price of all auctions.\n\nCREATE MATERIALIZED VIEW nexmark_q106\nAS\nSELECT\n MIN(final) AS min_final\nFROM\n (\n SELECT\n auction.id,\n MAX(price) AS final\n FROM\n auction,\n bid\n WHERE\n bid.auction = auction.id\n AND bid.date_time BETWEEN auction.date_time AND auction.expires\n GROUP BY\n auction.id\n )\n";