ACV Auctions Interview Question

Can you explain different JOINs