功能要求如下:
SELECT money,ROUND(money/6,2) from transinfo; SELECT sum(IF(MONEY*0.001<2,2,MONEY*0.001))FROM transinfo WHERE type='转入' or type='转出'; select city,TRUNCATE(sum(money*0.3),0) from card,user where city='北京' and user.userId=card.userId