有没有用过SqlSuger的大佬 多表联查怎么弄啊

Question

SELECT COUNT(1),h.type FROM ten_sample_ser_delivery d
JOIN ten_sample_hearse h ON
d.CarId=h.id
WHERE 
d.STATUS !='Abolished' AND d.STATUS !='canceled'
GROUP BY h.type

我裂开了 弄了我半天了