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

[@msanthosh3241]

bro continue i watched all of ur 50 videos

[@gospelmoto2833]

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

[@Chathur732]

Great question, great work! :)

[@MADMAX-hs2pr]

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

[@FuffFuf-z9q]

Thanks 👏 🎉

[@333Stan]

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

[@rishabhralli9151]

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 tr.arrival_time>=tr1.arrival_time 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

[@RITIKSINGH-re5ne]

Good Quesiton

[@g4uravrawat663]

which sql environment are you using?

[@zero_analyst]

PgAdmin 4

[@zero_analyst]

Start Data Career in 2025 (Best Course) 💼 Google Cybersecurity Professional Certificate imp.i384100.net/kO4n6L 💼 Microsoft Business Analyst Professional Certificate imp.i384100.net/NkOArq 💼 IBM Data Engineering Professional Certificate imp.i384100.net/Bn5Wv9 💼 Google Advanced Data Analytics Professional Certificate imp.i384100.net/6ykaYN 💼 Meta Data Analyst Professional Certificate imp.i384100.net/4Gakv1