Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- 3. Каких именно работ выполнено на максимальную сумму за период / сумма работников по типу работ ( время * тариф)
- */
- SELECT SUM(t.executhours*t.dengaden) AS dengaRab,
- listTypeWork.TypRabot
- FROM listTypeWork
- INNER JOIN
- (SELECT listBrigade.IdPersonFK,
- listBrigade.executHours,
- listBrigade.TypIdFK,
- listTypeWork.DengaDen
- FROM listBrigade
- INNER JOIN listTypeWork ON listBrigade.TypIdFK=listTypeWork.TypIdPK) t ON listTypeWork.TypIdPK=t.typidfk
- GROUP BY listTypeWork.TypRabot
- ORDER BY dengaRab;
Add Comment
Please, Sign In to add comment