Lab 3

SELECT delivererid,MAX(DATA),MIN(DATA)
FROM penalties
GROUP BY delivererid
HAVING COUNT(*)>=2;

SELECT p.delivererid, p.DATA, p.amount
FROM(
      SELECT delivererid,MAX(DATA) DATA
      FROM penalties
      GROUP BY delivererid) mdata, penalties p
WHERE p.delivererid=mdata.delivererid AND mdata.DATA=p.DATA;

SELECT companyid
FROM companydel
WHERE numdeliveries>=1 OR numcollections>=1
GROUP BY companyid
HAVING (10/3)*COUNT(*)>=(SELECT COUNT(*)
                  FROM deliverers);