FAANG SQL Interview Challenge | Calculate Total Club Points

🎯 SQL Challenge – Can You Solve This?

In this video, we’ll solve a real SQL interview-style problem involving reward points and club memberships.

Table Create Statements:
Create Table Club (
Club_Id int,
Member_Id int,
EDU varchar(30))

Insert into Club Values (1001,210,Null)
Insert into Club Values (1001,211,'MM:CI')
Insert into Club Values (1002,215,'CD:CI:CM')
Insert into Club Values (1002,216,'CL:CM')
Insert into Club Values (1002,217,'MM:CM')
Insert into Club Values (1003,255,Null)
Insert into Club Values (1001,216,'CO:CD:CL:MM')
Insert into Club Values (1002,210,Null)

🧩 Problem Statement:
You’re given a table named `Club` with three columns:
- Club_ID
- Member_ID
- EDU

A member can belong to multiple clubs, and the `EDU` column represents different rewards with the following point values:
MM – 0.5
CI – 0.5
CO – 0.5
CD – 1
CL – 1
CM – 1

Your task:
Write an SQL query to calculate the total points scored by each club.

💡 In this video, we’ll cover:
- How to approach this problem step by step
- Splitting Column using STRING_SPLIT function
- Using the CASE statement inside SUM
- Applying GROUP BY for club-level aggregation
- Tips for SQL interviews and practice problems
🔗Join SQL Junction Community

📢 Telegram: [https://t.me/sqljunction]
💼 LinkedIn: [https://www.linkedin.com/in/adityabansal095]
💡 Don’t Forget To

👍 Like the video
📝 Comment on your approach
🔔 Subscribe for more SQL Challenges every week!

#SQLInterview #SQLServer #SQLChallenge #DataEngineering #SQLTutorial #AdityaBansal #SQLJunction #DataScienceInterview #SQLQuestion #TechInterview #AdvancedSQL #interviewprep

keywords:[sql queries asked in interview for freshers,sql 4 years experience interview questions,sql 2 years experience interview questions]

Видео FAANG SQL Interview Challenge | Calculate Total Club Points канала Aditya Bansal