Hardest SQL Interview Questions for Data Analysts | Must Solve Data Science Interviews in 2024! #50

Learn SQL In 16-21 hrs (Basics to Advanced Concepts)
Learn with Me

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

[gospelmoto]

That was an amazing solution. My mind was left behind analyzing the problem.

[MADMAX-hspr]

Bro keep goin you are inspiring me to become better at my skills !

[Stan]

Please provide script or the questions in every video, so that we can practice from our side.

[rishabhralli]

with cte as(
select tr.train_id as trid, tr.arrival_time as trarrival, tr1.train_id as tr1id, tr1.arrival_time as tr1arrival, td.train_id as tdid, td.departure_time as tddept from train_arrivals tr join train_arrivals tr1 on
and tr.train_id!=tr1.train_id join train_departures td on tr1.train_id=td.train_id)
, cte1 as(
select *, case when tddept>trarrival then 1 else 0 end as tim from cte),
cte2 as(
select tr1id, count(*) as cn from cte1 where tim=1 group by 1)
select max(cn) as platform from cte2
another solution though its complex than yours

[zero_analyst]

Start Data Career in 2025 (Best Course)