select DRIVERS.NUM, CREWS.CODE as "Позывной", DRIVERS.NAME as "ФИО", count(*) as "Всего"
from CREWS, DRIVERS, ORDERS, ORDER_TARIFS
where ORDERS.STATE like '4' and
      ORDERS.INPUTTIME >= '01.02.2015 07:00' and
      ORDERS.INPUTTIME < '02.02.2015 07:00' and
      CREWS.ID = ORDERS.CREWID and
      ORDERS.DRIVERID = DRIVERS.ID and
      ORDER_TARIFS.ID = ORDERS.TARIF_ID or
      ORDERS.STATE like '36' and
      ORDERS.INPUTTIME >= '01.02.2015 07:00' and
      ORDERS.INPUTTIME < '02.02.2015 07:00' and
      CREWS.ID = ORDERS.CREWID and
      ORDERS.DRIVERID = DRIVERS.ID and
      ORDER_TARIFS.ID = ORDERS.TARIF_ID
group by DRIVERS.NUM, CREWS.CODE, DRIVERS.NAME

  NUM   Позывной    ФИО    Всего   ТИП10     ТИП15     ТИП20
  001      005      Оля     10       5         3         2
  001      006      Аня     15       5         5         5