Скачать или смотреть EY SQL Interview Questions asked for the Technical Business Analyst Role

✅EY SQL Interview question asked For Technical Business Analyst role👇


1.Delete duplicate data from the table only first data remains constant.

2.Find the Employees who were hired in the Last n months.

3.Delete duplicate data from the table so that only the first data remains consistent.

4.Write Query all names of employees with a salary greater than 50 000 together with employees who work in the 'IT' department.

5.Write Query names of all employees together with the ID of the department they work in, but you cannot use JOIN

6.Write a SQL query to create an empty table with the same structure as some other table.

7.Write a SQL query to fetch common records between two tables?

8.Write An SQL Query To Print Details Of The Workers Who Are Also Managers.

9.What is a Self-Join?

10.How we can update the view?

11. Find the companies for which the revenue has continuously increased over the years.

create table company_revenue
( company varchar(100), year int, revenue int );
insert into company_revenue values ('ABC1',2000,100),('ABC1',2001,110),('ABC1',2002,120),('ABC2',2000,100),
('ABC2',2001,90),('ABC2',2002,120) ,
('ABC3',2000,500),('ABC3',2001,400),('ABC3',2002,600),('ABC3',2003,800);


📌save this video and share with your friends and follow me for more useful content


Tags~
EY interview questions
SQL interview questions
EY SQL interview
business analyst interview
technical business analyst
EY technical round,
SQL for business analyst,
SQL tips for interview,
analytics interview questions,
data analyst interview,
technical interview 2025,
EY careers,
EY jobs,
business intelligence,
SQL query questions,
SQL joins interview,
SQL scenario-based questions,
business analyst 2025,
EY data analyst,
data analyst SQL questions


#sqlinterview#businessanalytics #interviewtips #Ey #EYInterview #SQLInterviewQuestions #BusinessAnalyst #TechnicalAnalyst #EYCareers #SQLTips #InterviewPreparation #DataAnalytics #BusinessAnalystInterview #SQLForAnalysts #EYJobs #TechInterview #CareerTips #AnalyticsCareer #Interview2025 #SQLPractice #EYTechnicalRound #DataDrivenJobs #AnalyticsInterview #SQL