Fantastic explanation, ma'am! Great teaching 👏👏👏 I loved how you solved the problem in a complex manner and then used a self-join to reduce the complexity. This video also helped me understand how powerful joins in SQL are. Looking forward to more videos on SQL. Thank you!
Thank you so much! 😊 I'm really glad you found the video helpful. Your support means a lot! Please don't forget to like, share and subscribe the video ,it motivates me to keep creating more videos.
SELECT seat_id FROM (SELECT seat_id,LEAD(seat_id) OVER(ORDER BY seat_id)-seat_id as lddiff, seat_id-LAG(seat_id) OVER(ORDER BY seat_id) as lgdiff FROM cinema WHERE free=1) as a WHERE lddiff=1 OR lgdiff=1;
I had a question that this was the only coding question asked here and also , was it an online interview? and also some other questions I want to ask you, because I have an interview on Thursday
I got this question from the Code360 platform, which offers SQL interview questions from various companies. If you have any questions, feel free to connect with me on LinkedIn and ask. Best of luck with your interview!
Amazing question
Fantastic explanation, ma'am!
Great teaching 👏👏👏
I loved how you solved the problem in a complex manner and then used a self-join to reduce the complexity.
This video also helped me understand how powerful joins in SQL are.
Looking forward to more videos on SQL.
Thank you!
Thank you so much! 😊 I'm really glad you found the video helpful. Your support means a lot! Please don't forget to like, share and subscribe the video ,it motivates me to keep creating more videos.
Simply superb, eager to practice more SQL with your other videos !
Thank you Priya! Stay tuned for more SQL videos.😊
Simply & superb
Thanks a lot!
SELECT seat_id FROM (SELECT seat_id,LEAD(seat_id) OVER(ORDER BY seat_id)-seat_id as lddiff,
seat_id-LAG(seat_id) OVER(ORDER BY seat_id) as lgdiff
FROM cinema
WHERE free=1) as a
WHERE lddiff=1 OR lgdiff=1;
Nice!
I had a question that this was the only coding question asked here and also , was it an online interview? and also some other questions I want to ask you, because I have an interview on Thursday
I got this question from the Code360 platform, which offers SQL interview questions from various companies. If you have any questions, feel free to connect with me on LinkedIn and ask. Best of luck with your interview!