pub const CREATE: &str = "-- Covers EOWC sort + EOWC over window.\n-- Note: we intentionally avoid the group-top-n/row_number pattern, which won\'t plan an over window.\n\nCREATE MATERIALIZED VIEW nexmark_q107_eowc AS\nSELECT\n auction,\n bidder,\n date_time,\n price,\n AVG(price) OVER (\n PARTITION BY auction\n ORDER BY date_time\n ROWS BETWEEN 10 PRECEDING AND CURRENT ROW\n ) AS avg_price_10,\n MAX(price) OVER (\n PARTITION BY auction\n ORDER BY date_time\n ROWS BETWEEN 10 PRECEDING AND CURRENT ROW\n ) AS max_price_10\nFROM\n bid\nWHERE\n auction % 100 = 0\nEMIT ON WINDOW CLOSE;\n";