> For the complete documentation index, see [llms.txt](https://jaywin.gitbook.io/leetcode/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jaywin.gitbook.io/leetcode/solutions/0603-consecutive-available-seats.md).

# 0603. Consecutive Available Seats

<https://leetcode.com/problems/consecutive-available-seats>

## Description

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.

## ac

```java
```