Oh god, I have done all the optimization in code, joining the tables and also have followed standards in writing the code. But still why…