There were in total 3 rounds

First round was coding+ Aptitude round

Second round was in person interview round

24 students were shortlisted for this round

We were asked question about probability, banking, data structures( verbally )

Third round was also interview round

8 students were selected for this round

I was asked questions about myself then we moved on to probability and puzzle questions, then I was asked a few SQL queries and we ended with a puzzle

In the end only 1 student was selected for this opportunity and I was not him.

SQL Questions

1. Write a SQL statement to get list of all students whose name starts with 'a'.

2. There is an employee table which consists of a list of all employees of an office month-wise and the columns are id, name, salary and month. You have to write a SQL statement to get a list of top 3 salary getters for each month.

Probability questions

1. There is a biased coin in which the probability of getting heads is 3 times more than tails, you toss the coin three times and each coin toss is independent. What is the probability of getting at most 2 tails.

2. There are 75 students in a class divided into 3 equal groups of 25 each, you have to pick 2 students from these 75. What is the probability of picking both students from the same group.

3. There are 5 black balls and 10 red balls in a basket. What is the probability that the third ball you picked will be a black ball and what is the probability that the last ball you pick will be black.

Data structures questions

1. What is the best sorting algorithm and what is its time complexity in each case (best, average and worst).

2. Explain merge sort and how does it work.

3. How do you find the square root of a number without using the Math.sqrt function.

4. How do you find if the given number is prime or not.