pg1

/*
1.  Сколько работник заработал за указанный период / время * тариф
*/

SELECT ss.IdPersonFK,
       SUM(ss.DengiRabochego) AS Dohod
FROM
  (SELECT listBrigade.IdPersonFK,
          listBrigade.executHours*listTypeWork.DengaDen AS DengiRabochego
   FROM listBrigade
   INNER JOIN listTypeWork ON listBrigade.TypIdFK=listTypeWork.TypIdPK) ss
GROUP BY ss.IdPersonFK
ORDER BY Dohod;