EPAM Systems interview question

Basic Sql questions like syntax, window functions, optimization.