编辑代码

---------------------------------------------------一年期----------------------------------------------------
-----------活期存款
select  '活期存款',
        JGFDMC as "机构法定名称",
        CPQC as "产品全称",
        CPCLYLLJSYL as "产品成立以来累计收益率",
        SJRQ as "数据日期"
from ZBD_YN_ZHLCPJBXXB_RE 
where CPQC in (select cpqc  
               from ZBD_YN_ZHLCPZCFZMXB_RE 
               where sjrq in ('20230331','20230430','20230531','20230630','20230731','20230831','20230930','20231031','20231130','20231231','20240131','20240229','20240331') 
                    and CKLX = '活期存款'
                    and ZCPJZCBL>0.9 
               group by cpqc,zcfzqyxmc 
               having count(ZCPJZCBL)>=12) 
      and sjrq = '20240331'


----------通知存款
select  '通知存款',
        JGFDMC as "机构法定名称",
        CPQC as "产品全称",
        CPCLYLLJSYL as "产品成立以来累计收益率",
        SJRQ as "数据日期"
from ZBD_YN_ZHLCPJBXXB_RE 
where CPQC in (select cpqc  
               from ZBD_YN_ZHLCPZCFZMXB_RE 
               where sjrq in ('20230331','20230430','20230531','20230630','20230731','20230831','20230930','20231031','20231130','20231231','20240131','20240229','20240331') 
                    and CKLX = '通知存款' 
                    and ZCPJZCBL>0.9 
               group by cpqc,zcfzqyxmc 
               having count(ZCPJZCBL)>=12) 
      and sjrq = '20240331'

-----------定期存款
select  '定期存款',
        JGFDMC as "机构法定名称",
        CPQC as "产品全称",
        CPCLYLLJSYL as "产品成立以来累计收益率",
        SJRQ as "数据日期"
from ZBD_YN_ZHLCPJBXXB_RE 
where CPQC in (select cpqc  
               from ZBD_YN_ZHLCPZCFZMXB_RE 
               where sjrq in ('20230331','20230430','20230531','20230630','20230731','20230831','20230930','20231031','20231130','20231231','20240131','20240229','20240331') 
                    and CKLX = '定期存款' 
                    and ZCPJZCBL>0.9 
               group by cpqc,zcfzqyxmc 
               having count(ZCPJZCBL)>=12) 
      and sjrq = '20240331'