BNY Team Lead Interview Questions and Answers

I am a dedicated and experienced team lead with a passion for motivating and guiding my team towards success.

• Experienced in leading teams to achieve goals

• Skilled in motivating team members

• Strong communication and problem-solving abilities

A complex SQL query involves multiple tables, joins, subqueries, and functions to retrieve specific data.

• Identify the tables and columns needed for the query

• Use JOIN statements to combine data from multiple tables

• Use subqueries to retrieve data from a subset of the main query

• Use aggregate functions like COUNT, SUM, AVG, etc. to perform calculations on data

• Use GROUP BY to group data based on a specific column

• Use HAVING ...read more

Program to find n numbers that sum up to a target number.

• Take input of target number and n

• Use a loop to take input of n numbers

• Check if sum of n numbers is equal to target number

• If yes, print the n numbers

• If no, try again with different n numbers