what are joins, views, group by clause, indexes , 3rd highest salary, row number, difference between functions and procedures, query optimization techniques, self join, primary key, foreign key, composite key, unique key

Fairly organized although process could have been much organized. If you want new employees(NEW GRADUATES OR FRESHERS) to pay you three lakh bugs and sign a three year agreement you should get +2 guys to and train them and put them to work instead of recruiting engineering grads