There was a screening interview from onshore, conducted via Skype. Following this, I was invited to the venue.

I was based in Chennai. They booked my flights and arranged pick-up and drop-off.

Then, I was interviewed by three people sequentially:

• First: Technical
• Second: Managerial
• Third: Managerial

1. Asked about the architecture of the current project.
2. How to display the sum of negative and positive values in different columns in a single column?
3. What is the difference between UNION and UNION ALL?
4. Outputs and count of rows for all different joins.
5. Difference between UNION and a full outer join.
6. How to display the name of a student whose aggregate is more than 200 in the students table?