🔥KPMG SQL INTERVIEW: New and Repeat Customers Explained!

This video provides a comprehensive explanation of a common SQL interview question asked at KPMG, focusing on identifying new and repeat customers. The SQL tutorial covers the basics of SQL query and SQL functions, including group by, order by, window functions, and case when statements, which are essential for data analysis and data science. By watching this video, you will learn SQL fast and gain valuable data skills, including how to write efficient SQL queries and perform data analysis using SQL. The video is designed for beginners and experienced data engineers alike, covering SQL basics, SQL tips, and advanced SQL concepts. Whether you are preparing for a SQL interview or looking to improve your data learning, this video will provide you with the necessary knowledge to learn SQL and become proficient in data analysis using SQL. By the end of this video, you will be able to answer common SQL interview questions and have a solid understanding of SQL coding and SQL join techniques. Timestamp 0:00 - Intro 0:09 - Problem Statement 2:10 - Solution 6:44 - Subscribe + Like if Helpful :) ----------------------------------------------------------------------------- Dataset drop table if exists orders; CREATE TABLE Orders ( Order_id int, Cust_id VARCHAR(10), Order_dt DATETIME, Order_amt DECIMAL(10,2) ); -- Insert sample data INSERT INTO Orders VALUES (1,'C1', '2025-01-01 09:15:00', 200.00), (2,'C1', '2025-01-01 16:45:00', 150.00), (3,'C2', '2025-01-01 10:20:00', 300.00), (4,'C3', '2025-01-02 11:10:00', 250.00), (5,'C1', '2025-01-02 13:00:00', 100.00), (6,'C1', '2025-01-03 09:30:00', 180.00), (7,'C2', '2025-01-03 15:50:00', 220.00); ----------------------------------------------------------------------------- Like ❤️, Share ↗️, and Subscribe 🔔 for more SQL tutorials, data analytics tips, and coding content! 👉 Check out daily quizzes on SQL and Python here:    / @datawithrupal   👉 Watch all SQL Shorts covering real interview problems, tips, tricks, and concepts here:    / @datawithrupal   👉 Explore detailed long tutorials and guides here:    / @datawithrupal   📸Follow me on Instagram for more data-related tips and learning resources:   / datawithrupal   #learnsql #sql #sqlinterviewquestions #shorts #shortsfeed #coding #subscribe #sqlqueries #dataanalytics #datascience #sqlquery #database #kpmginterviewquestion #dataanlysis #post