๐จ New YouTube Video Just Dropped!
๐ฏ Amazon SQL Interview Question Solved!
๐ฃ Learn how to calculate month-over-month percentage change in revenue โ a real SQL question asked in Amazon interviews!
๐บ Watch Now ๐
https://youtu.be/WrRA-hVDZ5I
๐ Donโt forget to: ๐ Subscribe to the channel ๐ฌ Drop your thoughts in the comments ๐ฃ Share with friends preparing for data interviews!
Please help me in reaching 500 subscribers.
#SQL #AmazonInterview #DataAnalytics #SQLInterview #SQLJunction
๐ฏ Amazon SQL Interview Question Solved!
๐ฃ Learn how to calculate month-over-month percentage change in revenue โ a real SQL question asked in Amazon interviews!
๐บ Watch Now ๐
https://youtu.be/WrRA-hVDZ5I
๐ Donโt forget to: ๐ Subscribe to the channel ๐ฌ Drop your thoughts in the comments ๐ฃ Share with friends preparing for data interviews!
Please help me in reaching 500 subscribers.
#SQL #AmazonInterview #DataAnalytics #SQLInterview #SQLJunction
YouTube
Amazon SQL Interview Question | Calculate Month-over-Month Revenue Challenge ๐ฅ
๐ AMAZON SQL INTERVIEW QUESTION THAT STUMPED MANY! ๐ฅ | Month-over-Month Revenue Challenge in SQL
If you're preparing for top-tier FAANG interviews, THIS VIDEO is your cheat code. ๐ง ๐ป
๐ Challenge:
Given a table of purchases by date, calculate the Month-overโฆ
If you're preparing for top-tier FAANG interviews, THIS VIDEO is your cheat code. ๐ง ๐ป
๐ Challenge:
Given a table of purchases by date, calculate the Month-overโฆ
โค1
๐จ Netflix SQL Interview Question Alert!
They asked this in an actual interview:
๐ฌ "Find the genre of the person with the most Oscar winsโฆ and join using names, not IDs."
Sounds simple? Itโs not.
Real-world SQL. Real logic. Real fun. ๐
I just posted a breakdown on LinkedIn โ check it out and drop a โNetflix ๐ฅโ to get the full solution!
๐ https://www.linkedin.com/posts/adityabansal095_sql-dataanalytics-sqlinterview-activity-7343592162338422785-OsV9?utm_source=share&utm_medium=member_desktop&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ
#SQL #Netflix #SQLJunction #DataEngineering #InterviewPrep
They asked this in an actual interview:
๐ฌ "Find the genre of the person with the most Oscar winsโฆ and join using names, not IDs."
Sounds simple? Itโs not.
Real-world SQL. Real logic. Real fun. ๐
I just posted a breakdown on LinkedIn โ check it out and drop a โNetflix ๐ฅโ to get the full solution!
๐ https://www.linkedin.com/posts/adityabansal095_sql-dataanalytics-sqlinterview-activity-7343592162338422785-OsV9?utm_source=share&utm_medium=member_desktop&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ
#SQL #Netflix #SQLJunction #DataEngineering #InterviewPrep
Linkedin
#sql #dataanalytics #sqlinterview #datascience #database #sqlquery #techinterview #dataengineering #learnsql #bigdata #datajobsโฆ
Dear Data Enthusiasts,
๐ฌ Netflix interview questions arenโt just cool โ theyโre designed to mess with your head (in a good way) ๐ฌ
๐ก๐๐ฎ๐๐ฌ๐ญ๐ข๐จ๐ง:
Find the genre of the person with the most Oscar wins.
If there's a tie, return the genre of the person whoseโฆ
๐ฌ Netflix interview questions arenโt just cool โ theyโre designed to mess with your head (in a good way) ๐ฌ
๐ก๐๐ฎ๐๐ฌ๐ญ๐ข๐จ๐ง:
Find the genre of the person with the most Oscar wins.
If there's a tie, return the genre of the person whoseโฆ
๐จ New Video Just Dropped!
๐บ Just uploaded a fresh YouTube video where I break down a Hard Google SQL interview question:
๐ฌ Compare the rating of an actorโs most recent film with the average of all their previous films.
If youโre preparing for SQL interviews or just want to level up your logic โ this is a must-watch!
๐ Watch here: https://youtu.be/gZ7ZKtKvL7s
๐ฅ Donโt forget to like, comment, and share if it helps!
Please help me in reaching 500 subscribers, Guys!!
#SQLJunction #SQLInterview #Google #DataEngineering #InterviewPrep #DataJobs
๐บ Just uploaded a fresh YouTube video where I break down a Hard Google SQL interview question:
๐ฌ Compare the rating of an actorโs most recent film with the average of all their previous films.
If youโre preparing for SQL interviews or just want to level up your logic โ this is a must-watch!
๐ Watch here: https://youtu.be/gZ7ZKtKvL7s
๐ฅ Donโt forget to like, comment, and share if it helps!
Please help me in reaching 500 subscribers, Guys!!
#SQLJunction #SQLInterview #Google #DataEngineering #InterviewPrep #DataJobs
YouTube
Google SQL Interview Question | Calculate Actor Latest VS Average Film Ratings ๐ฅ
๐ฌ Google SQL Interview Question โ Most Recent Film vs Average Rating Explained!
In this video, I break down a real SQL question asked in a Google interview:
๐ For each actor, calculate the difference between the rating of their most recent film and theirโฆ
In this video, I break down a real SQL question asked in a Google interview:
๐ For each actor, calculate the difference between the rating of their most recent film and theirโฆ
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 Interview Prep Kit ๐จ
1๏ธโฃ Aggregations
2๏ธโฃ Window Functions
3๏ธโฃ Set Operators
4๏ธโฃ Indexing for Performance
5๏ธโฃ SQL for Analytics
๐ฏ Perfect for quick revision before interviews or weekend practice!
#SQL #InterviewPrep #DataEngineering #SQLJunction
1๏ธโฃ Aggregations
2๏ธโฃ Window Functions
3๏ธโฃ Set Operators
4๏ธโฃ Indexing for Performance
5๏ธโฃ SQL for Analytics
๐ฏ Perfect for quick revision before interviews or weekend practice!
#SQL #InterviewPrep #DataEngineering #SQLJunction
Average SQL vs Great SQL.pdf
169.7 KB
๐ซ Most developers write SQL like this...
โ But great developers write it like this.
Just shared a visual breakdown of common SQL mistakes โ and how to fix them like a pro! โก
Perfect for anyone preparing for interviews or writing SQL daily.
๐ Upgrade your query game in 60 seconds.
#SQL #InterviewPrep #SQLTips #SQLJunction #SQLInterview
โ But great developers write it like this.
Just shared a visual breakdown of common SQL mistakes โ and how to fix them like a pro! โก
Perfect for anyone preparing for interviews or writing SQL daily.
๐ Upgrade your query game in 60 seconds.
#SQL #InterviewPrep #SQLTips #SQLJunction #SQLInterview
โค2
Hey folks ๐
I just created a clean and simple SQL cheat sheet โ perfect for quick revision before interviews or while working on projects.
It covers:
๐ธ DDL / DML / DCL / TCL
๐ธ All types of Joins
๐ธ Common Window Functions
๐ธ Aggregate functions
๐ผ๏ธ Check out the full image in the post ๐
๐ Save it for your reference
๐ค Share it with someone learning SQL
โ Aditya | SQL Junction
#SQL #SQLCheatSheet #DataEngineering #LearningSQL #SQLJunction
I just created a clean and simple SQL cheat sheet โ perfect for quick revision before interviews or while working on projects.
It covers:
๐ธ DDL / DML / DCL / TCL
๐ธ All types of Joins
๐ธ Common Window Functions
๐ธ Aggregate functions
๐ผ๏ธ Check out the full image in the post ๐
๐ Save it for your reference
๐ค Share it with someone learning SQL
โ Aditya | SQL Junction
#SQL #SQLCheatSheet #DataEngineering #LearningSQL #SQLJunction
โค2๐1
๐ 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โฆ
๐ฏ New SQL Interview Question on YouTube!
A real Deloitte Interview Question that tests: โข Window functions โข Logical thinking under pressure โข Your ability to connect dates correctly ๐ โ๏ธ
DELOITTE HARD SQL Interview Question in Hindi | Find Start and End Dates for Consecutive rows
https://youtu.be/ZPcV0OmSaIo
Most candidates struggle hereโฆ Can YOU solve it? ๐ค
Watch now ๐
๐ฅ
#SQL #InterviewPrep #DataEngineering #LearnSQL #SQLServer #Programming #SQLPractice #TechInterview #YouTubeChannel #SQLCommunity #SQLJunction #AdityaBansal
A real Deloitte Interview Question that tests: โข Window functions โข Logical thinking under pressure โข Your ability to connect dates correctly ๐ โ๏ธ
DELOITTE HARD SQL Interview Question in Hindi | Find Start and End Dates for Consecutive rows
https://youtu.be/ZPcV0OmSaIo
Most candidates struggle hereโฆ Can YOU solve it? ๐ค
Watch now ๐
๐ฅ
#SQL #InterviewPrep #DataEngineering #LearnSQL #SQLServer #Programming #SQLPractice #TechInterview #YouTubeChannel #SQLCommunity #SQLJunction #AdityaBansal
YouTube
DELOITTE HARD SQL Interview Question in Hindi | Find Start and End Dates for Consecutive rows
๐ฏ SQL Interview Challenge โ Can You Solve This?
In this video, we take a real-world problem involving event logs and use SQL window functions (ROW_NUMBER) to group consecutive records by date. This is a popular interview question used in top tech and dataโฆ
In this video, we take a real-world problem involving event logs and use SQL window functions (ROW_NUMBER) to group consecutive records by date. This is a popular interview question used in top tech and dataโฆ
FAANG SQL Challenge: Can you solve "The Delimiter Trap"? ๐งฉ
I just dropped a new breakdown of a classic interview problem that trips up even Senior Data Engineers.
The Task: Extract and calculate reward points from a single "messy" column (e.g., `'MM:CI:CD'`).
Why you should watch:
โ Learn the cleanest way to use
โ Master Conditional Aggregation (no more spaghetti code!).
โ Avoid the #1 over-engineering mistake candidates make in FAANG interviews.
Stop struggling with messy dataโmaster the logic in 5 minutes.
Watch the full solution here:
๐๐๐
https://youtu.be/Pg5F8_ViXE8
Which one is faster for thisโ`STRING_SPLIT` or
#SQL #InterviewPrep #DataEngineering #SQLJunction #SQLInterview
I just dropped a new breakdown of a classic interview problem that trips up even Senior Data Engineers.
The Task: Extract and calculate reward points from a single "messy" column (e.g., `'MM:CI:CD'`).
Why you should watch:
โ Learn the cleanest way to use
STRING_SPLIT.โ Master Conditional Aggregation (no more spaghetti code!).
โ Avoid the #1 over-engineering mistake candidates make in FAANG interviews.
Stop struggling with messy dataโmaster the logic in 5 minutes.
Watch the full solution here:
๐๐๐
https://youtu.be/Pg5F8_ViXE8
Which one is faster for thisโ`STRING_SPLIT` or
CROSS APPLY? Let me know in the YouTube comments! ๐#SQL #InterviewPrep #DataEngineering #SQLJunction #SQLInterview
YouTube
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โฆ
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โฆ
๐1