数据库课程设计--银行存取款管理

balance,15,'-')||v_record.总数);endloop;closemycur;endluinf;十、查询1、查询余额最多的人共取过多少次款,共取了多少钱selectcount(*),sum(money)fromlusernaturaljoindrawslipwherename=(selectnamefromluserwherebalance=(selectmax(balance)fromluser))2、查询存款余额大于200(亿)的储户,男女分别有多少人selectsex,count(*)fromluserwherebalance>200groupbysex3、查询哪个储户的某次存款期限满16个月,显示姓名、当次存款金额和性别selectname,money,sexfromlusernaturaljoindepositslipwhereextract(monthfromsysdate)-extract(monthfromdps_time)>44、查询哪些储户的取款总数大于100selectname姓名,sum(money)取款数,'亿'单位fromluserinnerjoindrawsliponluser.acnum=drawslip.acnumgroupbynamehavingsum(money)>1005、查询存款时间长度超过4个月的存款信息selectname姓名,dps_num存款单号,dps_time存款日期,extract(monthfromsysdate)-extract(monthfromdps_time)存款时间长度,'月'单位fromlusernaturaljoindepositslipwherebalance>400andextract(monthfromsysdate)-extract(monthfromdps_time)>=3