refactor 603

fishercoder1534 · fishercoder1534 · commit 44d1f517d6f2 · 2020-04-25T13:46:12.000-07:00
diff --git a/database/_603.sql b/database/_603.sql
@@ -1,25 +1,3 @@
---603. Consecutive Available Seats
---
---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 c.seat_id from cinema c where c.free = 1
 and
 (
