sqllab5

select first_name,last_name,bdate,name from patient,doctor d where (bdate=(select min(bdate) from patient) and name='reem' and d_id=d.id) or (bdate=(select max(bdate) from patient) and name='reem' and  d_id=d.id);
select d_name,price,status from drug,drug_AmountStatus where price=(select min(price)from drug) and status='abundant';
select sum(dr.price) from drug dr,drug_supplier s where dr.supplier_id=s.supplier_id and s.address='Amman'group by price having  sum(price)>40;
select address,count(*) from drug_supplier group by address;
select count(specialty) from doctor;
select s.supplier_name,max(d.price) from drug_supplier s,drug d where d.supplier_id=s.supplier_id  group by s.supplier_name having min(d.price)>12;
select s.supplier_id,avg(d.price) from drug_supplier s,drug d where s.supplier_id=d.supplier_id and price>(select price from drug where d_name='drug4') group by d.supplier_id;