EY SQL Interview Question | Joins | Group by clause | Udit Soni

🔥 Welcome to the Fifth Video of the SQL Interview Series! 🔥 Script: CREATE TABLE Transactions1 ( transaction_id INT PRIMARY KEY, company_id INT, transaction_date DATE, revenue DECIMAL(10, 2) ); INSERT INTO Transactions1 (transaction_id, company_id, transaction_date, revenue) VALUES (101, 1, '2020-01-15', 5000.00), (102, 2, '2020-01-20', 8500.00), (103, 1, '2020-02-10', 4500.00), (104, 3, '2020-02-20', 9900.00), (105, 2, '2020-02-25', 7500.00); --Table: Sectors CREATE TABLE Sectors ( company_id INT PRIMARY KEY, sector VARCHAR(50) ); INSERT INTO Sectors (company_id, sector) VALUES (1, 'Technology'), (2, 'Healthcare'), (3, 'Technology'); 📅 In this video, we tackle a REAL EY SQL interview question: “Calculate the average monthly revenue for each sector in 2020, displaying results month-by-month.” 🔥 What You’ll Learn: ✅ How to use GROUP BY for sector and month aggregation ✅ Master AVG() and date functions for financial analysis ✅ Optimize queries for year-specific filters (2020) ✅ Structure results for clear monthly performance insights 💡 Perfect for aspiring data analysts, engineers, or anyone prepping for SQL-heavy roles at top-tier companies. 🔔 Subscribe and hit the bell to master SQL interview questions! 👉 Like, Share, and Comment if you want more real-world SQL challenges! SQL interview questions and answers / EY SQL interview preparation / Calculate average monthly revenue SQL / GROUP BY month and sector SQL / SQL date functions / SQL query for monthly trends / Data analyst interview SQL questions / AVG() function with GROUP BY 🌐 Connect with Me: YouTube: https://www.youtube.com/@iuS1294 LinkedIn: https://www.linkedin.com/in/udit-soni-95ab2b236/ Instagram: https://www.instagram.com/utuberuditsoni/?igsh=MTQwanF1NG8zZHN0aQ%3D%3D# 🎯 Data Science Tutorial / Learn Data Science / Data Science for Beginners / Data Scientist Interview Preparation / Python for Data Science / Machine Learning Tutorial / AI and Data Science / Data Science Projects / SQL for Data Science / Data Science Course / Data Science Roadmap / Data Science Jobs / Data Science Internship / Big Data and Analytics / Data Visualization in Python / Data Science vs Machine Learning / Kaggle Competitions / Data Science Skills / How to Become a Data Scientist / Career in Data Science / Pandas Tutorial / NumPy Tutorial / Data Cleaning Techniques / Matplotlib and Seaborn / Feature Engineering / Exploratory Data Analysis (EDA) / SQL Queries for Interviews / Python Projects for Data Science / TensorFlow and PyTorch / Deep Learning Basics / ChatGPT and Data Science / Prompt Engineering in Data Science / AI-Powered Data Science Tools / LLM for Data Science Projects / Top Data Science Companies Hiring / Data Science in 2025 / Real-Time Data Analytics / Cloud Platforms for Data Science (AWS, Azure, GCP) / Data Science Success Stories / Data Science Career Transition / Day in the Life of a Data Scientist / Data Science Portfolio Tips / Top Data Science Mistakes / Salary of a Data Scientist / Is Data Science Worth It? #AI #DataScience #ChatGPT #Interview #Preparation #IITG #NITWarangal #IITJAM #GATE #Placement #PPO #NIMCET #BestMotivationalVideo #BestTips #UditSoni 🙏🏻 Thanks for Watching! Don't forget to Like, Share, and Subscribe to support the channel! 💯