oracle - 基于预订计数的客户详细信息

Question

编写查询显示用户在个人预订中预订的座位数大于1的用户id和用户名。按用户名升序显示记录。

我已经尝试过这个查询，但我遇到了错误。请帮我！！

select u.user_id,u.name 
     from users u join bookingdetails bd 
     on u.name=bd.name
     join tickets t on u.user_id=t.user_id
     group by u.name
     having count(t.no_seats) > 1
     order by u.name;

标签： oracle

Answer 1

select distinct u.user_id,u.name from users u 
join tickets t on u.user_id = t.user_id
where
u.user_id in( select user_id from tickets where no_seats>1)
order by u.name;