pub const CREATE: &str = "-- A self-made query that covers semi join.\n--\n-- Show the auctions that have at least 20 bids.\n\nCREATE MATERIALIZED VIEW nexmark_q103\nAS\nSELECT\n a.id AS auction_id,\n a.item_name AS auction_item_name\nFROM auction a\nWHERE a.id IN (\n SELECT b.auction FROM bid b\n GROUP BY b.auction\n HAVING COUNT(*) >= 20\n);\n";