Top SQL Interview Questions and Answers | 30 Days SQL Challenge |SQL Tutorials |Google - #19/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]

Stay connected for the latest updates, job opportunities, and data analysis tips!
Let's grow together!

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!

My Solution Link:

Music cc: YouTube-Channel Liborio Conti

[AmbarGharat]

WITH CTE AS (
SELECT
name,
COUNT(name) AS name_count
FROM
student_names
GROUP BY
name
HAVING
COUNT(name) > 1
)
SELECT
COUNT(DISTINCT name) AS distinct_name_count
FROM
CTE;

Is it right? Bit confused about question and this video solution

[kandulasujith]

the above query we can achieve through cte also

[rohith]

can we use window function rather then making group by and subquery?

[nithishbodapunti]

In the question it is mentioned not unique that means we need to have condition >1 and if it is unique then =1
If i am wrong can you please explain clearly