SELECT P.ID,P.NAME,P.SCORE,M.MEMBERCOUNT,M.LOGINNAME,M.MEMBERCOUNT,M.ROLE,C.RATIO,
P.SCORE*C.RATIO/100 AS MEMSCORE
FROM PROJECTINFO P,MEMBERSHIP M,CONTRIBUTERATIO C
WHERE P.ID = M.ITEMID
AND M.MEMBERCOUNT = c.MEMBERCOUNT
AND M.ROLE = c.ROLE
AND M.ITEMTYPE = C.ITEMTYPE
AND P.YEAR = 2006
ORDER BY P.NAME,M.ROLE;