Test Your SQL Skills | Real Interview Question | Asked At MNC

This video covers a real-world SQL interview question asked at PwC. The test includes five practical SQL problems, and in this video, I solve and explain the third question step by step. Ideal for freshers and professionals preparing for SQL and data analytics interviews.

Book 1 on 1 call for Data Analyst Career Guidance with me here :

https://topmate.io/govind_sapkade/1746030

Question 1 Watch here :
https://youtu.be/XaIEwyNZg7A?si=mA6sz5oYAzn56zOL

Question 2 Watch here :
https://youtu.be/Ch72ba3cfOA?si=mY9TzSEsg6u5RCEx

Code to create Table and Fill data

CREATE TABLE Employees_Info (
EmployeeID INT,
EmployeeName VARCHAR(50),
Department VARCHAR(50),
ManagerID INT,
HireDate DATE,
MonthlySalary INT,
SalesAmount INT,
Month DATE
);

INSERT INTO Employees_Info
(EmployeeID, EmployeeName, Department, ManagerID, HireDate, MonthlySalary, SalesAmount, Month)
VALUES
(1, 'Alice', 'Sales', 101, '2020-01-01', 90000, 150000, '2025-01-01'),
(1, 'Alice', 'Sales', 101, '2020-01-01', 90000, 200000, '2025-02-01'),

(2, 'Bob', 'Sales', 101, '2021-03-15', 85000, 100000, '2025-01-01'),
(2, 'Bob', 'Sales', 101, '2021-03-15', 85000, 120000, '2025-02-01'),

(3, 'Carol', 'HR', 102, '2019-07-10', 95000, 95000, '2025-01-01'),
(4, 'David', 'HR', 102, '2020-06-25', 87000, 0, '2025-02-01'),

(5, 'Evan', 'IT', 103, '2022-05-05', 80000, 60000, '2025-01-01'),
(5, 'Evan', 'IT', 103, '2022-05-05', 80000, 75000, '2025-02-01');

SQL interview questions, PwC SQL interview, SQL test questions, real world SQL problems, SQL query practice, data analyst SQL interview, SQL for data analytics, advanced SQL queries, SQL coding interview, SQL problem solving, PwC interview preparation, SQL case study, SQL scenario based questions, SQL select query, SQL joins interview, SQL aggregation functions, group by SQL, having clause SQL, SQL window functions, SQL CTE interview, SQL practice for freshers, SQL for experienced professionals, SQL interview challenge, SQL hands on practice, business SQL queries, SQL problem explained, SQL tutorial interview, SQL analytics questions, SQL performance queries, SQL mock interview, SQL test solved, SQL query explanation, SQL examples, SQL interview preparation 2026, data analytics interview questions, SQL roadmap, SQL learning path, SQL skills for analysts, SQL interview series, SQL questions with answers, SQL real interview questions, SQL problem walkthrough, SQL challenge video, SQL learning YouTube, SQL career preparation.

#SQLInterview
#SQLInterviewQuestions
#SQLChallenge
#SQLPractice
#DataAnalytics
#DataAnalyst
#TechInterviews
#MNCInterview
#CodingInterview
#Database
#LearnSQL
#SQLTips
#InterviewPreparation
#FreshersJobs
#ITJobs
#AnalyticsCareer
#DataJobs
#CareerInTech
#YouTubeShorts
#Reels

Видео Test Your SQL Skills | Real Interview Question | Asked At MNC канала Govind Sapkade