State Farm interview question

Talk about different SQL joins