Pregunta de entrevista de CRISIL

Inner Join, Left Join, Basic Aptitude question