eBay interview question

Walk me through an SQL query