救救孩子呀

[qq_43054836]

select
Coach.CITYCODE as 地区,
count(OrderRecords.ID) as 订单总数,
sum(orderclassprice * 2) as 总金额,
COUNT(distinct Coach.ENTERID) as 驾校,
count(distinct CoachID) as 教练,
sum(OrderRecords.ORDERPRICE) as 入账金额,
sum((orderclassprice * 2) - OrderRecords.ORDERPRICE) as 优惠金额,
count(distinct OrderRecords.STUDENTID) as 培训人数,
count(orderclassprice)*2 as 培训学时
from OrderRecords,OrderClass,Coach
where ORDERRECORDS.ORDERCLASSID = ORDERCLASS.ID and Coach.ID = ORDERCLASS.coachID group by Coach.CITYCODE


新人正在学习，请问这样的数据库语句用linq该在怎么写呀。。。

[qq_43054836]

dddddd

[VB业余爱好者]

好像有SQL转Linq的工具

[VB业余爱好者]

https://www.cnblogs.com/atom-wangzh/p/8485043.html