pub const CREATE: &str = "-- Covers group top-n.\n\nCREATE MATERIALIZED VIEW nexmark_q9\nAS\nSELECT\n id, item_name, description, initial_bid, reserve, date_time, expires, seller, category,\n auction, bidder, price, bid_date_time\nFROM (\n SELECT A.*, B.auction, B.bidder, B.price, B.date_time AS bid_date_time,\n ROW_NUMBER() OVER (PARTITION BY A.id ORDER BY B.price DESC, B.date_time ASC) AS rownum\n FROM auction A, bid B\n WHERE A.id = B.auction AND B.date_time BETWEEN A.date_time AND A.expires\n)\nWHERE rownum <= 1;\n";