select qid, question, (
       select sum(bonus) 
          from question_bonuses qb
          join group_attributes ga on ga.gaid=qb.gaid
          where qb.qid = q.qid
          and ga.ga_attr in (...respondent attribs...)
       ) as score
from questions q
order by score descending