可执行sql：
SELECT
oc.cabinet_id objectId,
CONCAT_WS( '/', di.driver_name, ri.plate_number ) driver,
tcc.business_mode businessMode,
so.name subName,
cci.carteam_name affName,
oo.order_No orderNo,
oo.book_Space_No bookSpaceNo,
oc.cabinet_No cabinetNo,
oc.cabinet_Type conType,
oo.order_type orderType,
ss.dispatch_type dispatchType,
st.remark remark,
oo.address address,
date_format( cc.settlement_date, '%Y-%m' ) endDate,
date_format( cc.settlement_date, '%Y-%m-%d' ) settlementDate,
cc.cost_status costStatus,
sum( cc.pay_amount ) total
FROM
t_ord_cabinet_cost cc
LEFT JOIN t_ord_cabinet oc ON oc.cabinet_id = cc.cabinet_id
LEFT JOIN t_ord_order oo ON oo.order_id = oc.order_id
LEFT JOIN t_sch_task st ON st.cabinet_id = oc.cabinet_id
LEFT JOIN t_sch_schedule ss ON ss.id = st.schedule_id
LEFT JOIN t_car_carteam_info cci ON cci.carteam_id = ss.carteam_id
LEFT JOIN t_dri_driver_info di ON ss.driver_id = di.driver_info_id
LEFT JOIN t_car_trailer_info ri ON ss.trailer_id = ri.trailer_id
LEFT JOIN t_sys_org so ON so.org_code = oo.org_code
LEFT JOIN t_cus_customer tcc ON tcc.customer_id = cc.settlement_customer_id
LEFT JOIN sys_user_info us ON us.user_id = tcc.salesman_id
WHERE
cc.cost_status IN ( 0, 3 )
AND ( cc.settlement_date IS NOT NULL OR cc.settlement_date != '' )
AND cc.break_rule_state IN ( 0, 2 )
AND cc.cost_type_code IN ( '26', '2', '3', '8', '9', '10' )
AND ( cc.pay_amount != 0 AND cc.pay_amount IS NOT NULL )
AND so.LEVEL = 2
AND so.minimum_guarantee = 1
AND oo.order_status != 0
AND ss.schedule_status = 4
AND tcc.settle_accounts = 1
GROUP BY
objectId,
so.org_code,
cci.carteam_id,
endDate,
di.driver_info_id,
ri.plate_number,
oo.order_id,
ss.id,
st.id,
tcc.business_mode,
cc.cost_status,
date_format( cc.settlement_date, '%Y-%m-%d' )
ORDER BY
driver,
objectId,
orderNo,
bookSpaceNo,
dispatchType,
endDate DESC
不可执行sql：
SELECT
oc.cabinet_id objectId,
CONCAT_WS( '/', sc.driver_name, sc.plate_number ) driver,
sc.business_mode businessMode,
oo.`company_name` subName,
sc.carteam_name affName,
oo.order_No orderNo,
oo.book_Space_No bookSpaceNo,
oc.cabinet_No cabinetNo,
oc.cabinet_Type conType,
oo.order_type orderType,
sc.dispatch_type dispatchType,
sc.task_remark remark,
oo.address address,
date_format( cc.settlement_date, '%Y-%m' ) endDate,
date_format( cc.settlement_date, '%Y-%m-%d' ) settlementDate,
cc.cost_status costStatus,
sum( cc.pay_amount ) total
FROM
t_ord_cabinet_cost cc
LEFT JOIN t_sett_cost sc ON cc.cabinet_cost_id = sc.cabinet_cost_id
LEFT JOIN t_ord_cabinet oc ON oc.cabinet_id = cc.cabinet_id
LEFT JOIN t_ord_order oo ON oo.order_id = oc.order_id
LEFT JOIN t_sys_org so ON oo.org_code = so.org_code
WHERE
cc.cost_status IN ( 0, 3 )
AND ( cc.settlement_date IS NOT NULL OR cc.settlement_date != '' )
AND cc.break_rule_state IN ( 0, 2 )
AND sc.cost_type_class IN ( 0, 1 )
AND ( cc.pay_amount != 0 AND cc.pay_amount IS NOT NULL )
AND so.LEVEL = 2
AND so.minimum_guarantee = 1
AND oo.order_status != 0
AND sc.schedule_status = 4
AND sc.settle_accounts = 1
GROUP BY
objectId,
so.org_code,
sc.carteam_id,
endDate,
sc.driver_info_id,
sc.plate_number,
oo.order_id,
-- ss.id,
-- st.id,
sc.business_mode,
cc.cost_status,
date_format( cc.settlement_date, '%Y-%m-%d' )
ORDER BY
driver,
objectId,
orderNo,
bookSpaceNo,
dispatchType,
endDate DESC
问题：为什么第一个sql语句可以执行，第二个sql语句不可执行？
