Coder Baba

Java projects 👆👆

Java projects 👆👆

4 Java projects 👇 with source code

🔥 Create an EPIC Animated Login Page! 💻✨ | HTML, CSS & JavaScript 🚀 #Shorts
https://fb.watch/vZA7-g7B5B/

https://www.facebook.com/share/v/15RDL1fhhN/

follow my facebook page

📊💻 Ace Your SQL Interview! 💼✨

🚀 Just uploaded a must-watch video on YouTube:
"SQL Interview Question: Calculate Cumulative Sum of Sales for Employees"


🔍 Learn step-by-step how to calculate the cumulative sum of sales for each employee. This tutorial is perfect for:
✅ SQL beginners
✅ Job seekers preparing for technical interviews
✅ Anyone looking to enhance their database skills

🎥 Watch the video now: https://youtu.be/baWTD9S0dpY

💡 Make your SQL skills stand out in interviews and secure your dream job!

💬 Let me know your thoughts in the comments, and don’t forget to like, share, and subscribe for more awesome content! 🚀

#SQLInterviewQuestions #SQLQuery #SQLTutorial #CumulativeSum #SQLJobs #LearnSQL #SQLForBeginners #InterviewPrep #CodingTutorial #DatabaseManagement

👉 Follow for more learning resources! 🌟

🚀 Master SQL for Interviews! 📊

💡 SQL Challenge: Ready to test your skills? Here’s a commonly asked SQL Interview Question that you must know to ace your next job interview! 👇

🔥 Question:
Write a SQL query to calculate the cumulative sum of sales for each employee. The result should include:
👉 EmployeeID
👉 SaleDate
👉 CumulativeSales



--SQL Code to Create the Table:

CREATE TABLE Sales (
EmployeeID INT,
SaleDate DATE,
SaleAmount DECIMAL(10, 2)
);


--Insert Sample Data into the Table

INSERT INTO Sales (EmployeeID, SaleDate, SaleAmount) VALUES
(1, '2024-01-01', 100.00), -- Employee 1 made a sale of 100 on Jan 1
(1, '2024-01-02', 150.00), -- Employee 1 made another sale on Jan 2
(1, '2024-01-03', 200.00), -- Employee 1 made another sale on Jan 3
(2, '2024-01-01', 120.00), -- Employee 2 made a sale on Jan 1
(2, '2024-01-02', 180.00), -- Employee 2 made another sale on Jan 2
(3, '2024-01-01', 200.00), -- Employee 3 made a sale on Jan 1
(3, '2024-01-03', 100.00), -- Employee 3 made a sale on Jan 3
(3, '2024-01-04', 50.00); -- Employee 3 made another sale on Jan 4

✨ Here’s the SQL Query Solution:
WITH CumulativeSales AS (
SELECT
EmployeeID,
SaleDate,
SaleAmount,
(SELECT SUM(SaleAmount)
FROM Sales AS S2
WHERE S2.EmployeeID = S1.EmployeeID
AND S2.SaleDate <= S1.SaleDate) AS CumulativeSales
FROM Sales S1
)
SELECT
EmployeeID,
SaleDate,
SaleAmount,
CumulativeSales
FROM CumulativeSales
ORDER BY EmployeeID, SaleDate;

📌 For a detailed explanation and additional learning, watch my YouTube video: 🎥
https://youtu.be/baWTD9S0dpY

👉 Follow for More Insights: @coder_baba
📌 Don't forget to share this post with others preparing for technical interviews!

#SQLInterviewQuestions #DatabaseSkills #SQLServer #LearnSQL #InterviewPreparation #CumulativeSum #CodingTips #coderbaba

🚀 Join Us on Facebook! 🌟

Hey there, amazing people! 🙌

I’ve just launched my Facebook page dedicated to bringing you awesome content, including funny reactions, daily vlogs, and much more! 🎥💥 If you love a good laugh and exciting reactions, come join the Stardust React community! 😎

Click here to follow and be a part of the fun:
👉 https://www.facebook.com/coderbaba

https://www.facebook.com/share/r/Xy6L5nrgB1LD8oqn/

https://youtube.com/shorts/kgaZVLjX4hc?feature=share

https://youtube.com/shorts/g8rCsznI-84?feature=share

Complete Project in one video👇👇
https://youtu.be/lX9MLcnjpgE?si=ZphNEQ5ei7j-UWPb

essential sql interview questions

1 Explain Order of Execution of SQL query
2 Provide a use case for each of the functions Rank, Dense_Rank & Row_Number
3 Write a query to find the cumulative sum/Running Total
4 Find the Most selling product by sales/ highest Salary of employees
5 Write a query to find the 2nd/nth highest Salary of employees
6 Difference between union vs union all
7 Identify if there any duplicates in a table
8 Scenario based Joins question, understanding of Inner, Left and Outer Joins via simple yet tricky question
9 LAG, write a query to find all those records where the transaction value is greater then previous transaction value
10 Rank vs Dense Rank, query to find the 2nd highest Salary of employee ( Ideal soln should handle ties)
11 Write a query to find the Running Difference (Ideal sol'n using windows function)
12 Write a query to display year on year/month on month growth
13 Write a query to find rolling average of daily sign-ups
14 Write a query to find the running difference using self join (helps in understanding the logical approach, ideally this question is solved via windows function)
15Write a query to find the cumulative sum using self join
(helps in understanding the logical approach, ideally this question is solved via windows function
#coderbaba #SQLTips

follow @coder_baba

Master Expense Management System in C# | One-Shot Full Tutorial
https://youtu.be/lX9MLcnjpgE