功能要求如下:
select round(money/7,2) from transinfo ;
select * FROM transinfo;
select sum(if(money*0.001>=2,money*0.001,2)) from transinfo where type='转入'or type='转出';
select name,money*0.3 from user,card where city='北京' and user.userId=card.userId;
select sum(truncate( card.money*0.3,0)) from user,card where city='北京'and user.userId=card.userId ;