1、题目描述 来源:力扣(LeetCode) 2、解题思路 两表联查,记得去重distinctc2.seat_id 3、提交记录 select distinct c2.seat_id from cinema c1,cinema c2 where c1.free=True and c2.free=True and (c1.seat_id-c2.seat_id=1 or c2.seat_id-c1.seat_id=1) 430ms