pub const CREATE: &str = "-- A self-made query that covers anti join.\n--\n-- This is the same as q103, which shows the auctions that have at least 20 bids.\n\nCREATE MATERIALIZED VIEW nexmark_q104\nAS\nSELECT\n a.id AS auction_id,\n a.item_name AS auction_item_name\nFROM auction a\nWHERE a.id NOT IN (\n SELECT b.auction FROM bid b\n GROUP BY b.auction\n HAVING COUNT(*) < 20\n);\n";