
delete from query;
/*1.daerah administrasi */
insert into query values (
     "create view xml_daerah_administrasi as select da.bulan as 'bulan', da.tahun as 'tahun', 
      p.nama as 'propinsi',da.kab as 'kabupaten', da.kota as 'kota', da.kec as 'kecamatan', 
      da.desa as 'desa' from daerah_administrasi da,mspropinsi p
      where da.pro=p.kode","xml_daerah_administrasi","jumlah daerah administrasi");

/*2.jumlah administrasi per propinsi */
insert into query values (
     "create view xml_administrasi_propinsi as
     select p.nama as 'propinsi', da.kab as 'kabupaten', da.kota as 'kota', da.kec as 'kecamatan', 
     da.desa as 'desa' from daerah_administrasi da,mspropinsi p where da.pro=p.kode",
     "xml_administrasi_propinsi","jumlah administrasi masing-masing propinsi");

/*3.luas daerah indonesia */
insert into query values (
     "create view xml_luas_daerah as
     select nama,la from mspropinsi","xml_luas_daerah","luas daerah");


