1 SELECT authid, workyear, SUM(workhours) AS "Total Hours" FROM worksession GROUP BY authid, workyear 2 L.payrate是唯一值么 是的话 SELECT W.bid, W.authid, W.workyear, (SUM(W.workhours) * max(L.payrate)) AS"Total Hours" FROM worksession W INNER JOIN allocation L ON L.bid = W.bid GROUP BY W.bid, W.authid, W.workyear ORDER BY bid, authid, workyear;
FROM worksession
GROUP BY authid, workyear
2 L.payrate是唯一值么 是的话
SELECT W.bid, W.authid, W.workyear, (SUM(W.workhours) * max(L.payrate)) AS"Total Hours"
FROM worksession W
INNER JOIN allocation L
ON L.bid = W.bid
GROUP BY W.bid, W.authid, W.workyear
ORDER BY bid, authid, workyear;