RSI interview question

Basic questions, focused alot on JOIN methods