MRI Software interview question

Join Statement SQL