Subway Business Development Associate Interview Questions and Answers

There were some aptitude question, Pandas question, SQL queries.

Q1. Use SQL to filter duplicate entries.
Ans. 
Use SQL query with DISTINCT keyword to filter duplicate entries.
• Use SELECT DISTINCT column_name FROM table_name;

• DISTINCT keyword removes duplicate values from the result set.

• For example, SELECT DISTINCT name FROM employees;

• You can also use GROUP BY clause to eliminate duplicates.
Answered by AI
Add your answer
Q2. Questions on Excel Shorcuts.
Add your answer

Q1. SQL Questions are asked, learn joins and aggregate functions
Add your answer

Simple Case Study was discussed

Q1. Company fit check and salary expectations
Add your answer

Q1. SQL Basic Question
Add your answer
Q2. SQL Medium Level Question
Add your answer

Q1. Live SQL Programming
Add your answer
Q2. Live Pyhton Programming
Add your answer

Q1. Case Study related to hotel industry
Add your answer
Q2. Root cause analysis of a scenario
Ans. 
Root cause analysis involves identifying the underlying reason for a problem or issue.
• Identify the problem or issue that needs to be analyzed

• Gather relevant data and information related to the problem

• Use tools like fishbone diagram or 5 Whys to dig deeper into the root cause

• Consider all possible factors that could have contributed to the problem

• Develop a plan to address the root cause and prevent future occurrences
Answered by AI
Add your answer

Basic aptitude question and 2 Sql question

Q1. 2 Sql question i on joins and other on window function
Add your answer
Q2. 1 Guestimate 1 Puzzle
Add your answer
Q3. Intoduction about your self
Add your answer
Q4. About your resume and interest
Add your answer

Q1. What are the use cases of self-join?
Ans. 
Self-join is used to join a table with itself to compare rows within the same table.
• Used to compare rows within the same table

• Helps in retrieving hierarchical data

• Can be used to find employees who report to the same manager
Answered by AI
Add your answer
Q2. How to extract nth highest salary?
Add your answer
Q3. What are the critical KPIs to be monitored after creating a new website?
Ans. 
Critical KPIs to monitor after creating a new website include traffic, conversion rate, bounce rate, and user engagement.
• Traffic: Monitor the number of visitors to the website to gauge its reach and popularity.

• Conversion Rate: Track the percentage of visitors who take a desired action, such as making a purchase or signing up for a newsletter.

• Bounce Rate: Measure the percentage of visitors who leave the website after vi...read more
Answered by AI
Add your answer
Q4. What would be the probability of getting at least one six after throwing 2 unbiased dice?
Ans. 
The probability of getting at least one six after throwing 2 unbiased dice is 11/36.
• The total number of outcomes when throwing 2 dice is 36 (6 sides on each die)

• The number of outcomes where at least one die shows a six is 11 (6 outcomes where one die shows a six, plus 1 outcome where both dice show sixes)
Answered by AI
Add your answer

SQL questions and logical reasoning

Q1. Talked about resume, projects and general questions of maths and logical reasoning
Add your answer

A guesstimate and a case study on profitability

Q1. SQL, and puzzles
Add your answer

Q1. Details discussion on Previous projects and Situation based questioning
Add your answer