Practice Interview Questions
| Question | Status |
|---|---|
Given a cinema_seats table, find all free seats (is_free) adjacent to another free seat.
cinema_seats sample:
| seat_id | is_free |
|---|---|
| 1 | 1 |
| 2 | 0 |
| 3 | 1 |
| seat_id |
|---|
| 3 |
| 4 |
| 6 |
Given a cinema_seats table, find all free seats (is_free) adjacent to another free seat.
cinema_seats sample:
| seat_id | is_free |
|---|---|
| 1 | 1 |
| 2 | 0 |
| 3 | 1 |
| seat_id |
|---|
| 3 |
| 4 |
| 6 |