Domanda di colloquio di eBay

Please finish this assignment by using SQL command or logic.