[数据库] MYSQL:这个查询有更好的写法吗?

引用:

SELECT sum( k.num ) , k.n_name
FROM (

SELECT count( a.id ) AS num, a.news_id, c.n_name, c.n_fl_id
FROM flux AS a
LEFT JOIN news AS b ON a.news_id = b.news_id
LEFT JOIN new_fl AS c ON b.n_fl_id = c.n_fl_id
GROUP BY a.news_id
) AS k
GROUP BY k.n_fl_id