Flipkart Health+ Business Analyst Interview Questions and Answers

Q1. Find 3rd highest salary using SQL
Ans. 
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
• Use SELECT statement to retrieve salary column

• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
Answered by AI
Add your answer
Q2. Queries on self join
Add your answer

Q1. Questions on Power B, DAX etc.,
Add your answer

Q1. Prepare on SQL in depth
Add your answer
Q2. Prepare on Excel & Python in depth
Add your answer

1. Tell me about yourself
2. Estimate the number of hospitals in India

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Q1. Salary negotiation on what were last salary and related questions
Add your answer
Q2. How soon can you join?
Add your answer
Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
Add your answer
Q4. Are you comfortable relocating to the office location?
Add your answer

8 SQL questions with increase in complexity and 1 case study

Q1. SQL and Statistics screaning
Add your answer

Q1. Business case studies, guess estimates, little technical
Add your answer

Q1. Complete profile screaning, Checking if candidate is suited for the role, case studies, guess estimates
Add your answer

Q1. Why sudden job change plan
Add your answer
Q2. Why Swiggy and what values did you see before applying
Ans. 
I chose Swiggy for its innovative technology, market leadership, and growth potential.
• Swiggy's cutting-edge technology in the food delivery industry stood out to me

• The company's strong market presence and leadership position were appealing

• I was impressed by Swiggy's rapid growth and expansion in the market

• Swiggy's customer-centric approach and focus on quality service were values I admired
Answered by AI
Add your answer

Q1. What do I do in my existing job?
Add your answer
Q2. Why do you want to leave your existing job?
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Why would you like to join our organisation?
Add your answer

Q1. Ques.1 How many delivery boy have called customers more than 5 times?
Ans. 
The number of delivery boys who called customers more than 5 times is not provided.
• Data on the number of delivery boys who called customers more than 5 times is missing.

• Need to gather data on the number of delivery boys and their call logs.

• Analysis can be done once the data is available.
Answered by AI
View 5 more answers
Q2. Question 2. Count distinct uniques names from the table
Ans. 
To count distinct unique names from a table, use the SELECT DISTINCT statement with the name column.
• Use SELECT DISTINCT to retrieve unique names

• Specify the name column in the SELECT statement

• Example: SELECT DISTINCT name FROM table_name

• Store the result in an array of strings
Answered by AI
Add your answer