BRNNAME SCORE COUNTS ALL_PERCENTAGE |
GRP_PERCENTAGE
--------------------------------------------------------|-----------------
CAPE COAST DELIGHTED 7 29.167000000000 |
CAPE COAST GOOD 1 4.167000000000 |
--------------------------------------------------------|-----------------
HOHOE DELIGHTED 4 16.667000000000 |
HOHOE GOOD 2 8.333000000000 |
HOHOE SATISFACTORY 1 4.167000000000 |
HOHOE UNHAPPY 1 4.167000000000 |
--------------------------------------------------------|------------------
KUMASI BAD 1 4.167000000000 |
KUMASI DELIGHTED 6 25.000000000000 |
KUMASI GOOD 1 4.167000000000 |
SELECT BRNNAME,SCORE,count(BRNNAME) AS COUNTS, ROUND(100.0*COUNT(BRNNAME)/(SELECT count(BRNNAME) FROM cte3),3)
as ALL_PERCENTAGE ,
ROUND(100.0*COUNT(BRNNAME)/(SELECT count(BRNNAME) FROM cte3),3)
as GRP_PERCENTAGE
FROM cte3 GROUP BY BRNNAME,SCORE
ORDER BY BRNNAME,SCORE
Need to compute percentages at the Branch level in addition
BRNNAME SCORE COUNTS ALL_PERCENTAGE |
GRP_PERCENTAGE
--------------------------------------------------------|-----------------
CAPE COAST DELIGHTED 7 29.167000000000 |
87.5%
CAPE COAST GOOD 1 4.167000000000 |
12.5%
--------------------------------------------------------|-----------------
Cape Coast has 8 counts (7+1)
Cape Coast
DELIGHTED = (7*100)/8= 87.5%
Cape Coast
GOOD = (1*100)/8= 12.5%
How do achieve the above.
Thanks
What I have tried:
Select statement under development