MYSQL 相关

1. 同一站点统计不同类型充电桩数量

SELECT
`ln_m_stake`.`STATION_ID` AS `station_id`,
COUNT(0) AS `num`,
SUM((CASE WHEN (`ln_m_stake`.`TYPE` = '1') THEN 1 ELSE 0 END)) AS `dcnum`,
SUM((CASE WHEN (`ln_m_stake`.`TYPE` = '2') THEN 1 ELSE 0 END)) AS `acnum`
FROM `ln_m_stake`
WHERE (`ln_m_stake`.`CHECK_STATUS` = '99')
GROUP BY `ln_m_stake`.`STATION_ID`$$