KSQL语句报错，

zxcvbnm123

select taobao_trades.* from taobao_trades taobao_trades where
taobao_trades.receiver_name in
(select taobao_trades.receiver_name as receiver_name
     from taobao_trades taobao_trades
where  taobao_trades.receiver_name!=''
group by taobao_trades.receiver_name
having count(taobao_trades.receiver_name)>=2
order by count(taobao_trades.receiver_name) desc)


请问这里是哪里出错了，谢谢

jishuang

别名不要相同