Several friends at a cinema ticket office would like to reserve consecutive available seats.
Can you help to query all the consecutive available seats order by the seat_id using the following cinema
table?
| seat_id | free | |---------|------| | 1 | 1 | | 2 | 0 | | 3 | 1 | | 4 | 1 | | 5 | 1 |
Your query should return the following result for the sample case above.
| seat_id | |---------| | 3 | | 4 | | 5 |
Note:
# OJ: https://leetcode.com/problems/consecutive-available-seats/
# Author: github.com/lzl124631x
SELECT DISTINCT
a.seat_id
FROM
cinema a JOIN cinema b
ON ABS(a.seat_id - b.seat_id) = 1
and a.free = true and b.free = true
ORDER BY a.seat_id