The following SQL produces the following table

 

SELECT "REGION_NAME" as "Region", sum("TOTAL_STAFF") as "Total Staff",sum("NO._MEMBERS") as "Total Members",abs(sum("NO._MEMBERS")/sum("TOTAL_STAFF") * 100) as "Penetration (%)" FROM "Schools Master List"
GROUP BY "REGION_NAME"
GO

Region                   Total Staff             Total Members       Penetration (%)

Eastern Metro               71                          63                          88.73

Western Metro             164                        121                        73.78

Southern Metro            401                        248                        61.85

Northern Metro           1060                       669                         63.11

 

 

I need a SQL script that produces the following table (all methods I use end in not supported or syntax error)