SQL Junction
2.92K subscribers
17 photos
1 video
7 files
90 links
Download Telegram
Sure! Here's a concise and engaging Telegram post you can use to share your YouTube video in your SQL Junctionchannel:

๐Ÿš€ NEW VIDEO DROP โ€“ SQL Interview Question from Netflix!
๐Ÿ”— Watch now on YouTube (Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friendsโ€™ Activity
https://youtu.be/GKY6TN1X4dY)

๐Ÿ“Œ Problem Statement:
You're given two tables โ€“ user_friends and user_pages.
Your task?
๐ŸŽฏ Recommend pages to users that they donโ€™t follow but at least one of their friends does.
This was asked in a real Netflix SQL interview!
โœ… In the video, I break down:
The logic step-by-step
How to write the SQL query
Key concepts like anti-joins, self joins, and recommendation filtering
Perfect for:
๐Ÿ”ธ SQL learners
๐Ÿ”ธ Data analyst/engineer interview prep
๐Ÿ”ธ Anyone curious how Facebook-style recommendations work under the hood!
๐Ÿ‘จโ€๐Ÿ’ป Watch now & level up your SQL skills!
๐ŸŽฌ Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friendsโ€™ Activity
https://youtu.be/GKY6TN1X4dY


#SQL #SQLJunction #NetflixInterview #SQLChallenge #DataEngineering #SQLQuery #TechInterview #TelegramLearning
๐Ÿš€ SQL Challenge #14 โ€” The Lift Capacity Problem is LIVE!



Youโ€™re given two tables โ€” LIFT and LIFT_PASSENGERS.
Multiple passengers can try to enter the same lift, but the total passenger weight cannot exceed the liftโ€™s capacity.

Your task?
๐Ÿ‘‰ Write an SQL query that returns a comma-separated list of passengers who can fit into each lift without exceeding capacity, ordered by their weight in ascending order.


In this video, Iโ€™ll walk you through my entire step-by-step solution in SQL Server, breaking down the logic clearly so you can learn, understand, and apply it in your own interviews ๐Ÿ’ผ

๐ŸŽฅ Watch the full video here:
๐Ÿ‘‰ https://youtu.be/8e-e1xYsgG0
https://youtu.be/8e-e1xYsgG0


๐Ÿ’ฌ Drop your approach in the comments โ€” letโ€™s see how you solved it differently!
๐Ÿ‘ฅ Share this with your SQL buddies who love a good challenge.


#SQLChallenge #SQLServer #SQLQuery #SQLInterview #SQLPractice #SQLJunction #LearnSQL
๐Ÿ˜ฒ 99% of SQL learners struggle with this problem!
You get a Club table where each member earns rewards like:
MM, CI, CO (0.5 pts each) CD, CL, CM (1 pt each)

๐Ÿ’ฅ Challenge: Calculate the total points scored by each club using SQL. Sounds simple? Wait till you try it. ๐Ÿ˜
Most people miss the key logic ๐Ÿ‘€
Can you crack it before watching the solution?
๐ŸŽฅ Full breakdown + solution:
๐Ÿ‘‰ SQL Challenge: Calculate Total Club Points | SQL Interview Question Explained
https://youtu.be/V-mMZ4hhhQE

#SQL #SQLChallenge #DataEngineering #SQLInterview #LearnSQL
๐Ÿš€ New SQL Hard Challenge is LIVE!

Todayโ€™s problem looks simpleโ€ฆ until you try it ๐Ÿ˜…
Youโ€™re given a table of products and categories โ€” and your task is to swap records inside each category using SQL window functions.

Most people get stuck on the logic ๐Ÿ‘€
Can YOU figure out the right approach before watching the solution?

๐ŸŽฅ Watch the full video here:
๐Ÿ‘‰ DELOITTE HARD SQL Interview Question in Hindi | Swap records Inversely

https://youtu.be/jOrTXXleDcg

If youโ€™re preparing for SQL interviews or just love brain-teasing SQL problems, this challenge is for you ๐Ÿ”ฅ

#SQL #SQLChallenge #DataEngineering #SQLInterview #PracticeSQL
๐Ÿ”ฅ1
๐Ÿง  Amazon SQL Interview Challenge
This is an interesting challenge ,please take a look

Ever tried applying Pythagoras theorem in SQL? ๐Ÿ˜„

Youโ€™re given triangle sides stored row-wise and your task is to identify which CombinationID forms a right-angled triangle.

๐Ÿ“ Rule to apply:
Hยฒ = Pยฒ + Bยฒ (longest side matters!)



If this showed up in an interview, how would you approach it?

https://www.linkedin.com/posts/adityabansal095_sql-amazon-amazoninterview-activity-7422150064292282368-fT9O

#SQL #SQLInterview #AmazonInterview #DataEngineering #Analytics #SQLChallenge
๐Ÿ”ฅ New YouTube Video Alert

Can You Solve This Deloitte SQL Interview Question?

Youโ€™re given a products table where the category is available only for the first product, while the following rows contain NULL.

Beverages โ†’ Coca Cola
NULL โ†’ Pepsi
NULL โ†’ Sprite
NULL โ†’ Fanta

Snacks โ†’ Lays
NULL โ†’ Doritos
NULL โ†’ Kurkure

๐ŸŽฏ Challenge:
How would you fill those NULL category values with the correct category?

๐Ÿ’ก Hint: Think about Window Functions ๐Ÿ‘€

This is a great SQL problem to test your understanding of NULL handling + data transformation.

๐Ÿ‘‡ What would you use?

๐Ÿ…ฐ๏ธ LAG()
๐Ÿ…ฑ๏ธ LEAD()
๐Ÿ…ฒ๏ธ LAST_VALUE()
๐Ÿ…ณ๏ธ ROW_NUMBER()

๐ŸŽฌ Solution video
Fill Missing Categories in SQL | Hard Deloitte Interview Question
https://youtu.be/IX9NBK3Yx-M
๐Ÿš€

Check it out now and let me know in comments ,What did you learn?

#SQL #SQLInterview #Deloitte #SQLChallenge #DataEngineering #Snowflake
๐Ÿ‘1