pub const CREATE: &str = "-- Covers group top-n (deduplication).\n--\n-- Note: the `ROW_NUMBER` is replaced with `RANK` to make the query result deterministic.\n\nCREATE MATERIALIZED VIEW nexmark_q18\nAS\nSELECT auction, bidder, price, channel, url, date_time, extra\nFROM (SELECT *, RANK() OVER (PARTITION BY bidder, auction ORDER BY date_time DESC) AS rank_number\n FROM bid)\nWHERE rank_number <= 1;\n";