kvi5hnu
@kvi5hnu
Published
🔺 SQL Query for Triangle Judgement | LeetCode SQL #32
🚀 In this video, we solve "Triangle Judgement" from LeetCode, a great problem to practice CASE WHEN statements and basic geometric conditions in SQL.
kvi5hnu2:42🔢 SQL Query for Consecutive Numbers | LeetCode SQL #33
🚀 In this video, we solve "Consecutive Numbers" from LeetCode, an essential problem to practice self-joins, DISTINCT, and pattern detection in SQL.
kvi5hnu9:33🚀 Find Product Price at a Given Date 🛒 | MySQL SQL Query Explained 💡
In this video, we solve the "Product Price at a Given Date" problem from LeetCode using MySQL. We break down the query step by step, explaining how to retrieve the most recent price before or on a given date using subqueries, ORDER BY, and LIMIT. We also handle cases where no…
kvi5hnu11:56🚌 Last Person to Fit in the Bus | MySQL SQL Query Explained 🚀
In this video, we solve the "Last Person to Fit in the Bus" problem from LeetCode using MySQL. We walk through how to calculate the cumulative sum of weights and determine the last person who can board without exceeding the weight limit.
kvi5hnu9:49💰 Count Salary Categories | MySQL SQL Query Explained 📊
In this video, we solve the "Count Salary Categories" problem from LeetCode using MySQL. We explain how to classify salaries into categories (Low, Average, High) and count the number of employees in each category, ensuring even missing categories are included using LEFT JOIN.
kvi5hnu14:32👨💼 Employees Whose Manager Left the Company | MySQL SQL Query Explained 🚀
In this video, we solve the "Employees Whose Manager Left the Company" problem from LeetCode using MySQL. We explain how to find employees earning less than $30,000 whose manager no longer exists in the company using CTEs, NOT IN, and subqueries.
kvi5hnu7:55🚀 ScribbleMate – The Ultimate Free Drawing Overlay for Android!
🚀 Introducing ScribbleMate – The Ultimate Free Drawing Overlay for Android!
kvi5hnu4:07🚀 ScribbleMate for Desktop/Mac! 🎨✍️
Watch “🚀 ScribbleMate for Desktop/Mac! 🎨✍️”, a 4-minute video walkthrough.
kvi5hnu3:45Experimenting with RSA + AES for True End-to-End Encryption
🔐 Experimenting with RSA + AES for True End-to-End Encryption
kvi5hnu3:40626. Exchange Seats – SQL Logic You NEED to Know! 🚀
Swapping adjacent seats has never been this fun! In this video, we solve the "Exchange Seats" SQL challenge from LeetCode’s Top 50 SQL problems. Watch as we crack this real-world logic puzzle using clean SQL in under a minute. Perfect for interviews and mastering conditional…
kvi5hnu8:361341. Movie Rating
In this video, we solve the "Movie Rating" problem from LeetCode using MySQL. We demonstrate how to find the most active user based on number of movie rated, and the highest-rated movie during a specific month — all in a single, elegant SQL query using UNION ALL.📌
kvi5hnu19:241321. Restaurant Growth – 📊 SQL Rolling Average Made Simple!
In this video, we solve the "Restaurant Growth" problem from LeetCode using MySQL. Learn how to calculate the 7-day rolling average of customer spending in a restaurant. We use Common Table Expressions (CTEs) and date filtering to generate insights from time-series data.
kvi5hnu20:52602. Friend Requests II – Who Has the Most Friends in SQL? 🔍
In this video, we solve the "Friend Requests II: Who Has the Most Friends" problem from LeetCode using MySQL. Learn how to find the user with the most number of accepted friend requests — including handling ties using a clean, multi-step approach.
kvi5hnu13:19585. Investments in 2016💰
In this video, we solve the "Investments in 2016" SQL problem from LeetCode — a perfect challenge to test your analytical thinking and mastery over conditional filtering. We'll walk through how to sum investment values based on unique location pairs and shared investment amounts…
kvi5hnu13:06185. Department Top Three Salaries – SQL Ranking Made Easy! 🏆
In this video, we solve the popular "Department Top Three Salaries" problem from LeetCode using MySQL. Learn how to find the top 3 earners per department using a clean and efficient subquery technique — no window functions required!
kvi5hnu9:121667. Fix Names in a Table – Clean & Format Strings in SQL 🧼
In this video, we solve the "Fix Names in a Table" problem from LeetCode using MySQL. Learn how to clean up and format names so each one starts with an uppercase letter followed by lowercase characters — a common real-world data cleanup task!
kvi5hnu2:381527. Patients With a Condition – SQL LIKE Query for Pattern Matching 🔍
In this video, we solve the "Patients With a Condition" problem from LeetCode using MySQL. You’ll learn how to filter rows based on partial string matches — specifically, identifying patients diagnosed with conditions that start with DIAB1.
kvi5hnu4:26196. Delete Duplicate Emails – Clean Your Data in SQL! 🧹
In this video, we solve the "Delete Duplicate Emails" problem from LeetCode using MySQL. Learn how to safely identify and remove duplicate rows using a self-join — a common real-world scenario in data cleanup tasks!
kvi5hnu7:18176. Second Highest Salary – SQL Interview Classic! 🔥
In this video, we solve the "Second Highest Salary" problem from LeetCode using MySQL. This is a classic SQL interview question that tests your understanding of ORDER BY, LIMIT, and handling edge cases with NULL.
kvi5hnu4:431484. Group Sold Products by the Date – Master GROUP BY & CONCAT in SQL! 🛒
In this video, we solve "Group Sold Products by the Date" from LeetCode using MySQL. This problem combines multiple key SQL concepts like aggregation, grouping, and string manipulation using GROUP_CONCAT.
kvi5hnu4:25