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 โ
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
๐ 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
YouTube
Netflix SQL Server Complex Interview Question Series | Recommend Pages Based on Friendsโ Activity
๐ Netflix SQL Interview Question Solved!
In this video, I walk through a real-life SQL interview question asked at Netflix.
๐ Problem Statement:
You're given two tables:
user_friends(user_id, friend_id) โ represents the Facebook friendship graph
user_pages(user_idโฆ
In this video, I walk through a real-life SQL interview question asked at Netflix.
๐ Problem Statement:
You're given two tables:
user_friends(user_id, friend_id) โ represents the Facebook friendship graph
user_pages(user_idโฆ
๐ 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
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
YouTube
Find Passengers That Can Fit in Each Lift | SQL Interview Question
In this video, we solve an interesting SQL problem that tests your ability to work with aggregations, joins, and string functions.
๐งฉ Problem Statement:
The relationship between the LIFT and LIFT_PASSENGERS tables is such that multiple passengers can attemptโฆ
๐งฉ Problem Statement:
The relationship between the LIFT and LIFT_PASSENGERS tables is such that multiple passengers can attemptโฆ
๐ฒ 99% of SQL learners struggle with this problem!
You get a
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
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
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
YouTube
DELOITTE HARD SQL Interview Question in Hindi | Swap records Inversely
In this video, we solve a very interesting SQL problem involving window functions and an update operation.
Youโre given a Products table with ProductID, Product, and Category.
The task is to swap the ProductIDs of the products within each category using SQL!โฆ
Youโre given a Products table with ProductID, Product, and Category.
The task is to swap the ProductIDs of the products within each category using SQL!โฆ
๐ฅ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
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.
๐ฏ 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
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 ColaNULL โ PepsiNULL โ SpriteNULL โ FantaSnacks โ LaysNULL โ DoritosNULL โ 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
YouTube
Fill Missing Categories in SQL | Hard Deloitte Interview Question
In this SQL interview question, we have a product table where the category is available for the first product but appears as NULL for the following products.
๐ฏ The challenge:
Fill the missing category values by carrying forward the last non-NULL categoryโฆ
๐ฏ The challenge:
Fill the missing category values by carrying forward the last non-NULL categoryโฆ
๐1