eBay Interview Question

Walk me through an SQL query