Pregunta de entrevista de ACV Auctions

2-3 SQL questions and 1 simple python pandas question. SQL was challenging