State Farm Interview Question

Talk about different SQL joins