Infosys interview question

Based on our skill regarding sql joins complex queries functions procedure