Constant CREATE 

pub const CREATE: &str = "-- Copied from q7, but runs in Emit-On-Window-Close mode to cover EOWC hash agg.\n\nCREATE MATERIALIZED VIEW nexmark_q7_eowc\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 \'2\' SECOND)\n    GROUP BY\n        window_end\n) B1 ON B.price = B1.maxprice\nWHERE\n    B.date_time BETWEEN B1.date_time - INTERVAL \'2\' SECOND\n    AND B1.date_time\nEMIT ON WINDOW CLOSE;\n\n";