SELECT 客户,驾驶员,车牌代码,车牌号,里程,数量,吨公里, 金额=
CASE
WHEN left(车牌代码,2)='01' AND (里程>41 AND 里程<=50) THEN 吨公里*0.043
WHEN left(车牌代码,2)='01' AND (里程>50 AND 里程<=60) THEN 吨公里*0.042
WHEN left(车牌代码,2)='01' AND (里程>60 AND 里程<=70) THEN 吨公里*0.040
WHEN left(车牌代码,2)='01' AND (里程>70 AND 里程<=80) THEN 吨公里*0.038
WHEN left(车牌代码,2)='02' AND (里程>41 AND 里程<=50) THEN 吨公里*0.0295
WHEN left(车牌代码,2)='02' AND (里程>50 AND 里程<=60) THEN 吨公里*0.0290
WHEN left(车牌代码,2)='02' AND (里程>60 AND 里程<=70) THEN 吨公里*0.0285
WHEN left(车牌代码,2)='02' AND (里程>70 AND 里程<=80) THEN 吨公里*0.0280
END
FROM Driver
CASE
WHEN left(车牌代码,2)='01' AND (里程>41 AND 里程<=50) THEN 吨公里*0.043
WHEN left(车牌代码,2)='01' AND (里程>50 AND 里程<=60) THEN 吨公里*0.042
WHEN left(车牌代码,2)='01' AND (里程>60 AND 里程<=70) THEN 吨公里*0.040
WHEN left(车牌代码,2)='01' AND (里程>70 AND 里程<=80) THEN 吨公里*0.038
WHEN left(车牌代码,2)='02' AND (里程>41 AND 里程<=50) THEN 吨公里*0.0295
WHEN left(车牌代码,2)='02' AND (里程>50 AND 里程<=60) THEN 吨公里*0.0290
WHEN left(车牌代码,2)='02' AND (里程>60 AND 里程<=70) THEN 吨公里*0.0285
WHEN left(车牌代码,2)='02' AND (里程>70 AND 里程<=80) THEN 吨公里*0.0280
END
FROM Driver
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货