EPAM Systems interview question

Question like how to improve query performance and remove duplicated data