Pergunta de entrevista da empresa eBay

Write a query for X situation (mainly group by, order by - no partitioning)