功能要求如下:
select money ,money/7 美元, round(money/7,2) x from transinfo
-- 如果每次转账操作,银行收取千分之一的手续费,不足2元,按2元收取,那么银行将收到多少的手续费
select * ,if(money*0.001>2,money*0.001,2) x from transinfo where type = '转入' or type='转出'
select sum(x) from(select * ,if(money*0.001>2,money*0.001,2) x from transinfo where type = '转入' or type='转出') c
-- 如果北京地区的客户,将银行卡存款的30%用户消费,计算总共会消费多少钱。计算截去小数,保留整数
select name,money,money*0.3 x from card, user where card.userid=user.userld and city='北京'
select truncate(sum(x),0) x from (select name,money,money*0.3 x from card, user where card.userid=user.userld and city='北京') c