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: / @ius1294
LinkedIn: / udit-soni-95ab2b236
Instagram: https://www.instagram.com/utuberudits...
🎯
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! 💯