MYSQL统计十二个月的数据；统计相同的数据的个数

根据十二个月统计每个月的金额

SELECT 
(sum(if (substring(leaveTime,6,2) = '01', payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a1',
(sum(if (substring(leaveTime,6,2) = '02' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a2',
(sum(if (substring(leaveTime,6,2) = '03' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a3',
(sum(if (substring(leaveTime,6,2) = '04' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a4',
(sum(if (substring(leaveTime,6,2) = '05' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a5',
(sum(if (substring(leaveTime,6,2) = '06' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a6',
(sum(if (substring(leaveTime,6,2) = '07' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a7',
(sum(if (substring(leaveTime,6,2) = '08' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a8',
(sum(if (substring(leaveTime,6,2) = '09' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a9',
(sum(if (substring(leaveTime,6,2) = '10' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a10',
(sum(if (substring(leaveTime,6,2) = '11' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a11',
(sum(if (substring(leaveTime,6,2) = '12' , payMoney,0)) + sum(if (substring(leaveTime,6,2) = '01', preMoney,0)) ) as 'a12',
sum(payMoney) as 'allpayMoney',
year(leaveTime) as year 
FROM car_allcar
WHERE year(leaveTime) in('2019') AND `parkId` =7

统计出相同的数据的个数

SELECT
	plateNo,
	entryTime,
	leaveTime,
	time,
	payMoney,
	COUNT( plateNo ) AS Account,
	COUNT( entryTime ) AS Account2 , 
	COUNT( leaveTime ) AS Account3 
FROM
	car_allcar
GROUP BY
	plateNo,
	entryTime,
	leaveTime,
	time,
	payMoney
HAVING
	Account > 1 
	AND Account2 > 1
	AND Account3 > 1
	AND payMoney > 1;