ACV Auctions interview question

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