EPAM Systems interview question

SQL queries with subquery, having clause and aggregate functions concepts. In C# they mostly asked questions regarding threading.