KPMG SQL Interview Question in Hindi | Find Total, Won & Lost Rides

In this video, I solve a real KPMG SQL interview question in Hindi. Problem Statement: The Delivery table contains four columns: Brand_1, Brand_2, Brand_3 and Winner. We need to write an SQL query to calculate: • Total number of rides • Number of rides won • Number of rides lost Table Create and Insert statements: CREATE TABLE Delivery_Partner ( Brand_1 VARCHAR(512), Brand_2 VARCHAR(512), Brand_3 VARCHAR(512), Winner VARCHAR(512) ); INSERT INTO Delivery_Partner (Brand_1, Brand_2, Brand_3, Winner) VALUES ('A', 'B', 'C', 'B'), ('B', 'C', 'E', 'E'), ('C', 'A', 'D', 'D'), ('D', 'E', 'A', 'A'), ('F', 'B', 'C', 'F'); 🔗Join SQL Junction Community 📢 Telegram: (https://t.me/sqljunction) 💼 LinkedIn: [  / adityabansal095  ] 📢 Telegram Affiliate : (https://t.me/smartpicks5) This question tests your understanding of aggregation, conditional counting, and SQL logic used in real interviews. If you are preparing for: ✔SQL interviews ✔Data Analyst roles ✔Data Engineering interviews ✔Big 4 companies like KPMG This type of question is very important. I explain the logic step-by-step in Hindi so you can clearly understand how to approach similar interview problems. 💡 Don’t Forget To 👍 Like the video 📝 Comment your approach 🔔 Subscribe for more SQL Challenges every week! #SQLInterview #SQLServer #SQLChallenge #DataEngineering #SQLTutorial #AdityaBansal #SQLJunction #DataScienceInterview #SQLQuestion #TechInterview #AdvancedSQL #interviewpreparation keywords:[sql queries asked in interview for freshers,sql 4 years experience interview questions,sql 2 years experience interview questions,Big4 SQL Interview Questions, Deloitte SQL Interview Question,SQL Project]