SQL | Find each flight's source and destination | Capgemini |

[@anasourdi4088]

Can you tell me which database system do you use ?

[@CodeSQL]

I use MSSQL, and I work with it through Docker and Azure Data Studio.

[@SquidOnGixxer]

???we can use lead lag??why make it complicated

[@CodeSQL]

Thanks for your suggestion! I'll definitely focus on making future videos simpler. Using LEAD and LAG is a great idea, and I'll include those concepts in an upcoming video. Appreciate your feedback!

[@CodeSQL]

Please find the new solution using LEAD and LAG here: kzbin.info/www/bejne/iYTEZputqMuGaKs

[@SquidOnGixxer]

@@CodeSQL great!