ZS Associates SQL Interview Question ( Medium Level) | Consecutive Available Seats 💡

แชร์
ฝัง
  • เผยแพร่เมื่อ 23 ธ.ค. 2024

ความคิดเห็น • 11

  • @soham_2
    @soham_2 2 หลายเดือนก่อน +1

    Amazing question

  • @pranavmahendra3423
    @pranavmahendra3423 2 หลายเดือนก่อน

    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!

    • @DatacraftingWithSneha
      @DatacraftingWithSneha  2 หลายเดือนก่อน +1

      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.

  • @PriyaK_27
    @PriyaK_27 2 หลายเดือนก่อน

    Simply superb, eager to practice more SQL with your other videos !

    • @DatacraftingWithSneha
      @DatacraftingWithSneha  2 หลายเดือนก่อน

      Thank you Priya! Stay tuned for more SQL videos.😊

  • @utkarshakulkarni1494
    @utkarshakulkarni1494 2 หลายเดือนก่อน

    Simply & superb

  • @harshitsalecha221
    @harshitsalecha221 2 หลายเดือนก่อน +1

    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;

  • @yashpise789
    @yashpise789 2 หลายเดือนก่อน +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

    • @DatacraftingWithSneha
      @DatacraftingWithSneha  2 หลายเดือนก่อน

      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!