【SQL】刷题整理[七]

一、力扣603. 连续空余座位

代码如下：

select distinct a.seat_id
from cinema as a,cinema as b
where a.free = 1 and b.free =1 and (a.seat_id = b.seat_id + 1 or a.seat_id = b.seat_id -1)
order by seat_id asc;

代码二：