Infosys Interview Question

Sql joins and type their function