如图所示数据表结构,若想调出以当前月为准所有员工(员工姓名需展示)水果销量前三的三种水果在每天每个人的销量数据,SQL语言应该如何编写?Select 日期,姓名,销量,水果 from(select 日期,姓名,销量,水果from 销量where datename between to_char(to_date('${datename}','yyyymmdd') -365 ,'yyyymmdd') and '${datename}')where 水果 in(Select 销量,水果 from(Select Row_number() over (partition by 姓名 order by 销量 desc)seq,销量,水果,姓名 from(Select 销量,水果,姓名 from(select 销量,水果,姓名 from 销量where datename between to_char(trunc(to_date('${datename}','yyyymmdd'),'mm') ,'yyyymmdd') and '${datename}''group by b.productname,lastreasoncode)))where seq<6)以上代码预览时提示值过多