Zypp Electric interview questions

Can you provide detailed information about the project you are currently working on at your company?

Gave An excel question - column a has numbers like 1 1 1 2 2 2 2 3 3 Expected output is - 1 2 3 1 2 3 4 1 2, write a formula in excel to get the expected output, basically the solution is to give ranking using formula - countif($a$2:a2,a2)

Second excel question - id date status 101 01-01-2025 Active 101 13-01-2025 Inactive 102 17-01-2025 Active 102 21-01-2025 Inactive So fiter the date to only show the row for each id having the highest date for each id.

One sql question - You are given a table called seats, which represents seat allocations in a movie theatre. Each row represents a seat and whether it is currently booked or empty. sample data seat_id status 1 booked 2 empty 3 empty 4 booked 5 booked 6 empty 7 empty 8 empty 9 booked 10 booked write an sql query to find all consecutive sequences of empty seats. For each sequence return - the starting seat_id, the ending seat_id and total count of consecutive empty seats. expected output - starting_seat_id ending_seat_id count_empty_seats 2 3 2 6 8 3