SQL优化：按月分组统计租赁合同数量和面积

SELECT su.real_name, COUNT(*), SUM(vc.rental_area), DATE_FORMAT(vc.signing_time, '%Y-%m') AS month FROM v4_contract vc LEFT JOIN v4_ebox.v4_customer_intention vci ON vc.customer_id = vci.customer_id LEFT JOIN v4_ebox.sys_user su ON vci.user_id = su.user_id WHERE vci.user_id IS NOT NULL AND vc.is_del = 0 AND vc.signing_time BETWEEN '2023-01-01' AND '2024-03-31' GROUP BY su.user_id, month