---------------------------------------------------一年期---------------------------------------------------------------活期存款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.9groupby cpqc,zcfzqyxmc
havingcount(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.9groupby cpqc,zcfzqyxmc
havingcount(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.9groupby cpqc,zcfzqyxmc
havingcount(ZCPJZCBL)>=12)
and sjrq = '20240331'