sql语句计算百分百

SELECT  b.circles_name,b.num, a.total,CONCAT(CAST(round((b.num*1.0/a.total)*100,2) AS CHAR),'%') as rate
FROM (SELECT COUNT(1) AS total FROM "person" 
WHERE setid='1001')AS a,
(SELECT circles_name, COUNT(circles_name) AS num FROM 
"person" WHERE delete_mark = 0 AND 
setid ='1001' GROUP BY circles_name) AS b
SELECT  from person

说明：
1、count（1），统计记录数
2、COUNT(circles_name)，按列名统计记录数
3、与count相关的 知识点 sum（列名），是对字段内的数量相加
4、GROUP BY聚集
5、as 别名