查询table_1表中的
按field_1字段分组统计id_1的数量
作为c字段,
c字段作为一个临时中间表table_tem,
统计table_tem表的c字段的平均值即为终极目标结果result_1。
SELECT avg(c) AS result_1
FROM
(SELECT count(id_1) AS c
FROM
table_1
GROUP BY field_1) AS table_tem
参考资料:
https://blog.csdn.net/findmyself_for_world/article/details/42123201