SQL 查询语句：统计项目报告数据

select\u0020x.C_ID,\u0020y.C_ID\u0020as\u0020C_IDS,\u0020y.C_STATUS,\u0020sum(z.m9),\u0020sum(z.m1),\u0020sum(z.m2),\u0020sum(z.m3),\u0020sum(z.m4),\u0020sum(z.m5),\u0020sum(z.m6),\u0020sum(z.m7),\u0020sum(z.m8),\u0020x.C_NAME\u0020from\u0020db_twenty.t_place\u0020x\u0020LEFT\u0020JOIN\u0020db_twenty.t_projectreportbatch\u0020y\u0020ON\u0020(\u0020y.R_STATEMENT_ID\u0020=\u0020?\u0020AND\u0020x.C_ID\u0020=\u0020y.R_PLACE_ID\u0020)\u0020LEFT\u0020JOIN\u0020db_twenty.t_projectreports\u0020z\u0020ON\u0020(\u0020z.C_TOWID\u0020=\u0020x.C_ID\u0020and\u0020z.C_ANNUAL*100+z.C_PERIOD<=?\u0020and\u0020z.C_DELETED\u0020=\u00200\u0020)\u0020WHERE\u0020x.R_PARENT_ID\u0020=\u0020?\u0020AND\u0020x.C_DELETED\u0020=\u00200\u0020GROUP\u0020BY\u0020x.C_ID