Cold Case~70min
The Quiet Cartel
Four vendors always win procurement contracts in rotation. Their bids are always within 2% of each other. Vendor A wins 48% of contracts. The same procurement officer approves all.
Tables you'll query
vendorsrfpsbidspurchase_orders
What you'll learn
Window FunctionsCTEs (WITH clause)SubqueriesJOINsAggregations & GROUP BY