Every derived table must have its own alias (每个派生表必须有自己的别名)
原因
**错误写法**
SELECT SUM( cnts) FROM (SELECT power_type,COUNT(*) cnts FROM ods_jingli GROUP BY power_type)
解决方法
SELECT SUM(a.cnts) FROM (SELECT power_type,COUNT(*) cnts FROM ods_jingli GROUP BY power_type) a
给子表加上别名