Suresh

• May 11th, 2006

 

DISTRICT   STUDENTNO  STATUS
---------- ---------- -
EG         1          P
EG         2          P
EG         3          F
WG         4          F
WG         5          P
WG         6          F

select district, 100*sum(decode(status,'P',1,'F',0))/count(1) PCT from results
group by district;

DISTRICT          PCT
---------- ----------
EG         66.6666667
WG         33.3333333

For simplicity, district was added in the same table.