Indra interview question

Inner join, left join, sql, etc....