Interview was focused on both programming and logic based questions. Starting from sql then the coding questions, main focus was on recursion and optimization. They asked to optimize the solution. In sql unions and joins were asked.