data analyst sql interview questions and answers #44/100 | HSBC | SQL Tutorials | SQL Tutorials

preview_player
Показать описание
Welcome to Day 44 of my 100 Days Challenge!

Get the question
Type !question 400 -- to get first question & datasets
Type !question 373 -- to get second question & datasets

Join me as I walk through each problem step-by-step, providing detailed explanations and practical tips. Don't forget to like, subscribe, and hit the bell icon to stay updated with daily challenges!

Links:
GitHub Repository - Get the question & datasets

Best Data Analytics Course:

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

#SQL #DataAnalysis #PortfolioProject #DataCleaning #BusinessAnalysis #DataAnalyst #SQLProject #EDA #SQLTutorial #GitHub #DataScience #CareerInData #LearnSQL #SQLforDataAnalyst #AspiringDataAnalyst #ResumeProject #EndToEndProject
Рекомендации по теме
Комментарии
Автор

🎯 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

zero_analyst
Автор

SELECT actor_id, director_id, count(actor_id) as act_count, count(director_id) as dir_count
FROM ActorDirector
group by actor_id, director_id
having count(director_id) >= 3 and count(actor_id) >=3

Chathur
Автор

select actor_id, director_id FROM ActorDirector GROUP BY actor_id, director_id HAVING COUNT(timestamp)>=3;

HARSHRAJ-gpve