π― LeetCode SQL: Percentage of Users Attended a Contest | SQL Query Explained Step-by-Step
Notes
π In this video, we solve the "Percentage of Users Attended a Contest" problem from LeetCode, where we calculate the percentage of users who participated in each contest. This problem is great for practicing SQL aggregation and subqueries!
π What Youβll Learn:
β
Using Common Table Expressions (CTEs) for cleaner queries
β
Calculating percentages using COUNT() and ROUND()
β
How to use GROUP BY and ORDER BY effectively
β
Best practices for writing optimized SQL queries
π Problem Link:
https://leetcode.com/problems/percentage-of-users-attended-a-contest
π» SQL Topics Covered:
βοΈ Common Table Expressions (WITH)
βοΈ COUNT() & Aggregation
βοΈ ROUND() for formatting percentages
βοΈ GROUP BY & ORDER BY
π’ If you find this video helpful, donβt forget to LIKE π, SUBSCRIBE π, and COMMENT below with your thoughts! π
#SQL #LeetCode #Database #CodingInterview #SQLQueries
Discussion
Sign in to ask a question or share what you learned.