Pergunta de entrevista da empresa NRI FT India

SQL Joining questions, join the above 2 tables having different criteria specified by the interviewer.