🚨 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

Job Alert for freshers

Join our Pune team as a Business Analyst (0-3 yrs exp)! We're looking for talent with SQL, Excel, and basic Python skills. Analyze business needs, develop solutions, and drive growth. Send your resume and let's discuss!

Interested candidates can directly share your resume on ygurnani@integrichain.com

Note - Candidate must be based in Pune

#BusinessAnalyst #Pune #JobOpening #CareerOpportunity

https://smrtr.io/rCSGG

Hello SQL folks

I have posted another good interview question on one of my linked in post

https://www.linkedin.com/posts/adityabansal095_sql-interviewprep-dataanalytics-activity-7338418464438530050-ttYS?utm_source=share&utm_medium=member_ios&rcm=ACoAAB8c2Z8Bcu4nHPJW24bZAavnMChCO7Q0wCQ

Please do take a look

I am currently preparing a playlist on YouTube for SQL interview questions
With your support , we will learn SQL in a way that will give us the confidence to crack any interview

https://youtube.com/playlist?list=PLU1HobJd_JCqjcZwUCc6s8avJutoIjyIF&si=IHwwl58XgAfWFYk7


Link to the playlist
Please subscribe and help me in reaching 500 subscribers

Thank you 🙏

I have been getting lot of DMs from
Folks about learning DBT?
I’m thinking to conduct a webinar to walk you through entire DBT tool and show you how it is gaining traction in the data world?

Are you guys interested?

If this poll gets enough votes , I will come up with DBT session very soon🤔

Thank you engineers
This position was filled by some body from this group🤗

Keep learning and opportunities will automatically come your way

This is still
Open
I have only received 50 votes.
I will stop this poll on Monday and will see it from there.

🚨 SQL Challenge — Real-World Use Case

You’re given a log table with 3 columns:
📅 record_date,
🏦 account_id,
👤 user_id

Task:
🔍 For each account, identify users who came back after 7+ days of inactivity.

Sounds simple, right?
But to solve this, you’ll need to:

* Use LAG() to compare login dates
* Calculate gaps between logins per user
* Filter only those who returned after 7+ days
* Do all of this per account, not globally

This is exactly the kind of logic you’ll face in interviews and real projects.

Here’s the SQL solution 👇

🧠 SQL Solution:


WITH user_logins AS (
SELECT
account_id,
user_id,
record_date,
LAG(record_date) OVER (
PARTITION BY account_id, user_id
ORDER BY record_date
) AS prev_login
FROM user_activity_log
),
login_gaps AS (
SELECT *,
DATEDIFF(day, prev_login, record_date) AS gap_days
FROM user_logins
)
SELECT DISTINCT
account_id,
user_id
FROM login_gaps
WHERE gap_days >= 7;

📩 For more such real-world SQL questions?
Join the LinkedIn posts and weekly YouTube drops:
🔗 https://www.youtube.com/playlist?list=PLU1HobJd_JCqjcZwUCc6s8avJutoIjyIF

📌 Stay tuned here for more!

#SQL #DataEngineering #InterviewPrep #SQLInterview

🚨 Urgent Hiring: Data Analyst / MIS-WFM Manager @ GlobalLogic, Gurgaon

Are you a data-driven professional with a passion for optimizing performance and uncovering insights? Join GlobalLogic in Gurgaon as a MIS & Workforce Management (WFM) Team Manager and take charge of transforming operational efficiency through smart analytics and workforce planning.

In this leadership role, you'll manage a skilled MIS/WFM team, create high-impact dashboards, and collaborate cross-functionally to ensure billing accuracy and data-backed decision-making. Your expertise in Excel, forecasting models, and reporting will drive critical business outcomes.

✅ What You’ll Need:
5+ years in MIS or WFM, ideally in service-based industries
Strong command of Excel (formulas, pivots, macros)
Exposure to Amazon Connect, Monte Carlo simulations, and SARIMA/ARIMA forecasting
Knowledge of BE6 billing models
Bonus: Power BI or Tableau skills
Excellent stakeholder communication & sharp analytical thinking

💼 Key Responsibilities:
Lead MIS & WFM initiatives for reporting, forecasting, and planning
Build dashboards using Excel/Power BI for real-time insights
Monitor and optimize key metrics: staffing, schedule adherence, occupancy
Ensure billing accuracy, reconcile timesheets, and manage invoices
Drive strategic decisions through data storytelling and collaboration

This is an urgent hiring ,it looks like to be a data analyst role
Salary for right candidate is around 15-18 LPA

Please reach out to me immediately on LinkedIn
If you are interested
LinkedIn.com/in/adityabansal095

🚨Hiring Data Analyst Freshers!

If you’re skilled in SQL, Python, Power BI & Excel and can join within 15 days, this is your chance.

Fresh minds. Real data. Big impact.

🔗 Apply now: https://lnkd.in/gP6YgNVK

Tag & share with someone who needs this!

🚨 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

🚨 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

Hey Folks
Apologies
I have been busy with the past month with freelance hiring.

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 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