大概写了一下,英文随便取的,你可以优化一下
select user_name,address,year ,(water_taotal * price.one_price + water_taotal * price.base_price + water_taotal * price.slop_price) as total ,(water_taotal * price.one_price) as one_total...