ACV Auctions interview question

Can you explain different JOINs