Select Code to Download

create table questions (
   QID number constraint questions_pk primary key,
...
-- But pain relief is more welcome in this case...
insert into question_bonuses (qid, gaid, bonus)
values (2, 6, .3);

select qid, question, (
       select sum(bonus) 
...
       ) as score
from questions q
order by score descending