摘要： SELECT licensePlate, SUM( CASE WHEN inOrOut = 'in' THEN 1 ELSE 0 END ) AS 'incount', SUM( CASE WHEN inOrOut = 'out' THEN 1 ELSE 0 END ) AS 'outcount' 阅读全文