pub const CREATE: &str = "-- A self-made query that covers outer join.\n--\n-- Monitor ongoing auctions and track the current highest bid for each one in real-time. If\n-- the auction has no bids, the highest bid will be NULL.\n\nCREATE MATERIALIZED VIEW nexmark_q101\nAS\nSELECT\n a.id AS auction_id,\n a.item_name AS auction_item_name,\n b.max_price AS current_highest_bid\nFROM auction a\nLEFT OUTER JOIN (\n SELECT\n b1.auction,\n MAX(b1.price) max_price\n FROM bid b1\n GROUP BY b1.auction\n) b ON a.id = b.auction;\n";