Sintak Basis Data
NAMA : Reinaldi Januar Ramdhan
KELAS : D3 TI 2B
NPM : 1143037
1. Select kddokter, nmdokter, spesialisasi, golongan
from dokter
where golongan=2;
2. select * from pasien
where umur<=12;
3. select * from pasien
where umur between 10 and 25
order by nmpasien desc;
4. select count(*) from pasien
where jenkel='W' and umur>15;
5. select count(*) from pasien
where jenkel='L' and umur<17;
6. select kdpasien from trklinik
where tglperiksa='12-DEC-2007'
order by kdpasien desc;
7. select sum(biaya) from trklinik
where kdpasien='PS002';
8. select kdpasien, sum(biaya) from trklinik
group by kdpasien;
9. select kddokter, avg(biaya) from trklinik
group by kddokter;
