Exchange Seats | Leetcode 626 | Crack SQL Interviews in 50 Qs

[@learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on Instagram Handles :- @createwithchirag - instagram.com/createwithchirag/ @learn.with.chirag - instagram.com/learn.with.chirag/ LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/ Let's stay connected and keep the creativity flowing! 💡

[@kartikeysingh1670]

thanks 👍👍👍👍

[@nikhilpandey4118]

👍👍👍👍

[@decodewithd2541]

This is one of the best channel I have come through while struggling SQL. This is really a good quality of content . Thank you so much sir :)

[@learnwithchirag]

Thanks a lot ! help me reach to thousands of more students like you ....Do share with your friends if you find my videos helpful ❤️

[@arghyadas2836]

Can you please solve this using LAG and COALESCE as well??

[@sonavijapure]

🥲omg it was so easy why i did not think in this way i have written such long query 😓 I still need lot of practice 😓

[@santoshsahu5611]

Hi Chirag! wonderful explanation, I'm still new to this and just wanted to understand the part where we used the subquery to get the max(id), could we not directly use the max(id) without the subquery?

[@vishalmane3139]

what is ids r nt consecutive.. wt will be the query ?

[@apoorvpradhan5125]

Thank you bhaiya

[@prathamsrivastava3153]

sir can you please share a solution where we are actually supposed to change the table

[@learnwithchirag]

Can you please elaborate? What do you mean by changing the table ?🤔

[@chetansahu1505]

This guy eats 100 sql queries every breakfast.

[@learnwithchirag]

Haha 😂...Glad you are liking the video...Do share with your friends too 🎉💐