Pergunta de entrevista da empresa Protechsoft Technologies

joins,inner joins,aggregrate functions,subquery,optimize the given query