Big 4 SQL Interview Questions | Data Analyst SQL Interview Questions | PWC | Deloitte | KPMG | EY

Hi Learners! This is part of the initial screening test of SQL for one of the Big4 companies. In this video, we will be discussing this assignment's problems one by one and the step-by-step approach to solution.

You can use the below commands to create the table and insert the values.

1. To Create the Table:
Create table employee_abc(e_id int, e_name varchar(20), e_salary INT, e_age INT, e_gender varchar(20), e_dept varchar(20));

2. To Insert the values:
INSERT INTO employee_abc values(1, 'Sam', 95000, 45, 'Male', 'Operations'), (2, 'Bob', 80000, 21, 'Male', 'Support'),(3, 'Anne', 125000, 25, 'Female', 'Analytics'), (4, 'Julia', 73000, 30, 'Female', 'Analytics'), (5, 'Matt', 159000, 33, 'Male', 'Sales'),(6, 'Jeff', 112000, 27, 'Male', 'Operations');


For a detailed understanding of SQL, refer to my Master SQL series.

Do subscribe to the channel for more videos and grab your dream job in data analytics.

YouTube: @AnalyticsWithVipul
Whatsapp: [phone]

Got a question about the solution? Please share it in the comment section below.

If you also have an interesting problem that was asked in any of your previous interviews, do share it in the comment box and if I find it interesting, I will make a solution video on that in the future.

Thank You
Vipul Gupta

[tejasmane]

Hi, why we used 1.20 to multiple with prev salary since 20% of prev salary means we need to multiply it with 0.20 right? no?

[Nitin_Wadhwa]

Hello , I'm Nitin this side. I've completed my graduation in commerce and looking for a skill development course. So what should i do . Should i move to tech side like data analyst or should i continue in non tech .. nd pls suggest me some high paying jobs . I'm So confused.

[mohammedhasnain]

Do big4 ask this much easy questions???