CoStar Group interview question

Do you know SQL and what are the different joins?