SaveBySwitching Business Analyst Interview Questions and Answers

Q1. Details about yourself
Add your answer
Q2. Personal information
Add your answer

They asked question from sql from join group by and from excel they asked about xlookup, vlookup, sumif,countif etc

Q1. What analysis you have done in your previous organization
Add your answer
Q2. Find third manager for an employee on sql
Ans. 
Use SQL query to find the third manager for an employee
• Join the employee table with the manager table on the manager_id

• Use a subquery to count the number of managers for the employee

• Filter the results to only include the third manager
Answered by AI
Add your answer

Q1. Sumifs Functions
Add your answer
Q2. Vlookup Function
Add your answer

Question regarding convergence rate

Q1. Sql triggers code
Add your answer
Q2. Vlookup, hlookup, match and indexing
Add your answer

Q1. Basic Sql questions
Add your answer
Q2. Basic python questions
Add your answer

Q1. Joins and their output
Ans. 
Joins are used in SQL to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN re...read more
Answered by AI
Add your answer
Q2. Employees who earn more than their manager
Add your answer