SQL> select * from mytable;

TYPE_CODE  EM SANC_AMOUNT DIST_AMOUNT
---------- -- ----------- -----------
rural      x           10           0
urban      y           12           6
rural      z           15          15
urban      a           12           8
rural      n           22           3
urban      a            1           1

6 rows selected.

SQL> select type_code,count(type_code), f8(type_code),f9(type_code),f10(type_code) from mytable
  2  group by type_code;

TYPE_CODE  COUNT(TYPE_CODE) F8(TYPE_CODE) F9(TYPE_CODE) F10(TYPE_CODE)
---------- ---------------- ------------- ------------- --------------
rural                     3            47            18              2
urban                     3            25            15              3

SQL> get f8
  1  create or replace function f8(n varchar2) return number is
  2  retval number;
  3  a number;
  4  begin
  5  select sum(sanc_amount) into a
  6             from mytable
  7             where type_code=n;
  8  retval:=a;
  9  return retval;
 10* end;
SQL> /

Function created.

SQL> get f9
  1  create or replace function f9(n varchar2) return number is
  2  retval number;
  3  a number;
  4  begin
  5  select sum(dist_amount) into a
  6             from mytable
  7             where type_code=n;
  8  retval:=a;
  9  return retval;
 10* end;
SQL> /

Function created.

SQL> get f10
  1  create or replace function f10(n varchar2) return number is
  2  retval number;
  3  a number;
  4  begin
  5  select     count(decode(dist_amount,0,null,
  6             dist_amount)) into a from mytable
  7             where type_code=n;
  8  retval:=a;
  9  return retval;
 10* end;
SQL> /

Function created.