L603_Consecutive_Available_Seats.sql

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:
The seat_id is an auto increment int, and free is bool ('1' means free, and '0' means occupied.).
Consecutive available seats are more than 2(inclusive) seats consecutively available.



SELECT DISTINCT a.seat_id
FROM cinema a 
JOIN cinema b
ON a.seat_id=b.seat_id-1 OR a.seat_id=b.seat_id+1
WHERE a.free=1 and b.free=1
ORDER BY a.seat_id;


/*
drop table cinema;

create table cinema (seat_id int, free int);

insert into cinema values (1,1);
insert into cinema values (2,0);
insert into cinema values (3,1);
insert into cinema values (4,1);
insert into cinema values (5,1);
*/