Constant CREATE

pub const CREATE: &str = "-- Covers self-join.\n\nCREATE MATERIALIZED VIEW nexmark_q5\nAS\nSELECT AuctionBids.auction, AuctionBids.num FROM (\n    SELECT\n        bid.auction,\n        count(*) AS num,\n        window_start AS starttime\n    FROM\n        HOP(bid, date_time, INTERVAL \'2\' SECOND, INTERVAL \'10\' SECOND)\n    GROUP BY\n        window_start,\n        bid.auction\n) AS AuctionBids\nJOIN (\n    SELECT\n        max(CountBids.num) AS maxn,\n        CountBids.starttime_c\n    FROM (\n        SELECT\n            count(*) AS num,\n            window_start AS starttime_c\n        FROM HOP(bid, date_time, INTERVAL \'2\' SECOND, INTERVAL \'10\' SECOND)\n        GROUP BY\n            bid.auction,\n            window_start\n    ) AS CountBids\n    GROUP BY\n        CountBids.starttime_c\n) AS MaxBids\nON AuctionBids.starttime = MaxBids.starttime_c AND AuctionBids.num >= MaxBids.maxn;\n";