LTM Limited interview question

Questions were asked from SQL joins