Infosys interview question

Sql joins and type their function