电影院查询4个连坐的人，sql该如何写

select a.seat,b.seat,c.seat,d.seat from test a,test b,test c,test d where a.seat+1=b.seat and b.seat+1=c.seat and c.seat+1=d.seat AND a.status='未预定' AND d.status='未预定' AND b.status='未预定' AND c.status='未预定'