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

[@zero_analyst]

🎯 Get Latest SQL Guided Project (1M sales records)
🎯topmate.io/zero_analyst/1237072
🎯 Get Latest
End to End Advanced SQL Project (Amazon)+ 70 Business Problems
ruclips.net/video/J9qFIAH788Q/видео.html
🐍 All Python Projects:
Python ETL - Data Cleaning Project
ruclips.net/video/uDQO9xOg4xg/видео.html

[@Chathur732]

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

[@swapnilchavan8378]

Bro your discord link not working 😔

[@zero_analyst]

Please use this link!
discord.gg/nYRHeMn66N

[@HARSHRAJ-gp6ve]

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