pub const CREATE: &str = "-- A self-made query that covers singleton top-n (and local-phase group top-n).\n--\n-- Show the top 1000 auctions by the number of bids.\n\nCREATE MATERIALIZED VIEW nexmark_q105\nAS\nSELECT\n a.id AS auction_id,\n a.item_name AS auction_item_name,\n COUNT(b.auction) AS bid_count\nFROM auction a\nJOIN bid b ON a.id = b.auction\nGROUP BY a.id, a.item_name\nORDER BY bid_count DESC\nLIMIT 1000;\n";