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