Most asked SQL Interview Questions and Answers | 30 Days SQL Challenge |SQL Tutorials |IBM - #12/30

📁 Get the code:

Get all my latest SQL project!
🎯 Get Latest SQL Guided Project (1M sales records)

🎯 Get Latest
End to End Advanced SQL Project (Amazon)+ 70 Business Problems

🐍 All Python Projects:
Python ETL - Data Cleaning Project

🛢All SQL Projects
Project 1:

Project 2:

Project 3: (Advanced SQL)
🎯 Zomato Food Company Data Analysis

Project 4:
🎯 Netflix Movies Data Analysis

Project 5:
🎯 Amazon Sales Analysis (Advanced SQL)

Project 6:
🎯 Spotify Data Analysis

Project 7: (Advanced SQL)
🎯 Apple Retail Sales Analysis - 1M Sales Records

Project 8: (Real Business Problems)
🎯 Monday Coffee Extensions Analysis

Best Data Analytics Course:

My Other YouTube Videos -
SQL 30 Days Road Map - [Free Learning Resources]

Ready to CRUSH your Data Analyst or Business Analyst interview? Join me on this 30-DAY SQL INTERVIEW CHALLENGE!

In this video, we'll dive DEEP into an ACTUAL Interview Question for Business Analyst and Data Analyst interview question. I'll walk you through:

Understanding the problem statement: We'll break down the question clearly and identify key requirements.
Building the optimal SQL query: Step-by-step, we'll craft an efficient and accurate solution using JOINs, aggregations, and filters.
Explaining your thought process: Learn how to articulate your problem-solving approach and showcase your SQL expertise.
BONUS TIPS & TRICKS: Gain valuable insights for acing your SQL interview with confidence.
Don't forget to:

Like this video and subscribe for more daily challenge videos!
Leave a comment with your own approach to the question.
Share this video with your fellow job seekers!
This is just the beginning! Subscribe now and stay tuned for Day 2's challenge!

IBM Interview Questions:

My Solution Link:

Music cc: YouTube-Channel Liborio Conti

[Raghavabablu]

Select user_id, sum(amount_spent)
from purchases
where extract(month from date_of_purchase) =02
group by user_id
having sum(amount_spent)>10000

[Raghavabablu]

i have a doubt what if date of purchase is different per user.can u explain this

[hiteshsharma-qtum]

What if we dont know about the dates present in the data set he said solve the query without getting to know about the date and find out present month total of the dataset which we dont know what is the latest date additionally find out last month total

may I know how we can solve?