603. Consecutive Available Seats

select distinct c1.id from cinema c1, cinema  c2

where abs(c1.id-c2.id) =1 and c1.free = 1 and c2.free =1

group by c1.id

posted @ 2018-10-22 11:07  ffeng0312  阅读(93)  评论(0编辑  收藏  举报