pub const CREATE: &str = "-- Covers self-join.\n\nCREATE MATERIALIZED VIEW nexmark_q7\nAS\nSELECT\n B.auction,\n B.price,\n B.bidder,\n B.date_time\nFROM\n bid B\nJOIN (\n SELECT\n MAX(price) AS maxprice,\n window_end as date_time\n FROM\n TUMBLE(bid, date_time, INTERVAL \'10\' SECOND)\n GROUP BY\n window_end\n) B1 ON B.price = B1.maxprice\nWHERE\n B.date_time BETWEEN B1.date_time - INTERVAL \'10\' SECOND\n AND B1.date_time;\n";