Infosys SQL Data Analyst Interview Question | EP-01| #sql #sqlinterview #dataengineering #sqltips

🚀 Ace Your SQL Interview with Confidence!
In this video, I walk you through one of the most frequently asked SQL interview questions:
👉 "Find the Manager's Name Who Manages More Than 4 Employees"

🔍 You'll learn:

👉How to structure the query
👉Step-by-step explanation of the logic
👉SQL concepts used in solving the problem

Whether you're preparing for an interview or just brushing up your SQL skills, this video will give you a solid understanding of a commonly discussed query.

💡 Don't forget to like, comment, and subscribe for more SQL interview tips and tricks!

📌 Chapters:
0:00 Intro
00:18 Structure of table
00:26 Understanding Query
02:06 Writing Query to fetch the details

Script:-

CREATE TABLE Employees(
ID INT,
FullName VARCHAR(50),
Department VARCHAR(50),
ManagerID INT
);

INSERT INTO Employees (ID, FullName, Department, ManagerID) VALUES
(1, 'Rajesh Kumar', 'IT', 6),
(2, 'Priya Sharma', 'HR', 6),
(3, 'Ravi Verma', 'Finance', 1),
(4, 'Sita Patel', 'IT', 1),
(5, 'Arjun Singh', 'Marketing', 2),
(6, 'Neha Mehta', 'IT', NULL),
(7, 'Karan Malhotra', 'Finance', 2),
(8, 'Meera Gupta', 'HR', 3),
(9, 'Aditya Roy', 'Marketing', 1),
(10, 'Riya Kapoor', 'IT', 2),
(11, 'Vikram Desai', 'Finance', 1),
(12, 'Anjali Nair', 'HR', 2),
(13, 'Sanjay Pandey', 'IT', 3),
(14, 'Mohan Das', 'Finance', 3),
(15, 'Leela Rao', 'HR', 1),
(16, 'Ashok Iyer', 'Marketing', 1),
(17, 'Kavita Yadav', 'IT', 2),
(18, 'Rahul Tiwari', 'Finance', 3),
(19, 'Sunita Chawla', 'HR', 1),
(20, 'Asha Gupta', 'Marketing', 2);

#sql #plsql #trend #sqlqueryinterviewquestionsandanswers #sqlinterview
#infosys #postgresql #sqlserver #oraclesql #2025 #capgemini#infosys #dataanalyst #dataanlysis #interview

[siddhantprakash.]

can't this be done without using join?
that is by simply using group by and having cont>4?