Chase Interview Question

what types of join? sas codes questions