I really need help. Anyone can help me compose this I really appreciate it. SQL is just not my thing.

I know the parts you mentioned but its just...

I really have no clue.

I figure there is a SUM() involved.

I fixed the wrong table structure in top of this message.