title: SUM 3 different "CASE" columns with three different totals
body: <p>I'm new to this so I'm sorry if I asked this question wrong. But I'm trying to get 4 different SUM's from my table that uses 4 different cases. But I want the id to be listed only once with the totals. I'll show you what I have, and what I'm trying to get. Please help if possible.</p>
  
  <pre><code>    SELECT schools.name, articles.competition_place,
  
      Case when articles.competition = 'yes' and competition_place = '1' then int '100'
         when articles.competition = 'yes' and competition_place = '2' then int '60'
         when articles.competition = 'yes' and competition_place = '3' then int '20'
      ELSE 0 end AS "Competition_Score",
  
      Case when articles.out_reach = 'yes' then int '30'
          ELSE 0 end AS "out_reach_Score",
  
      CASE when schools.school_id is not null then int '5'
          ELSE 0 end as "article_score",
  
      (Case when articles.competition = 'yes' and competition_place = '1' then int '100'
          when articles.competition = 'yes' and competition_place = '2' then int '60'
          when articles.competition = 'yes' and competition_place = '3' then int '20'
          ELSE 0 end) +
      (Case when articles.out_reach = 'yes' then int '30'
          ELSE 0 end) +
      (CASE when schools.school_id is not null then int '5'
          ELSE 0 end) as "total_score"
      from articles
      join clubs on articles.club_id = clubs.club_id
      join schools on clubs.school_id = schools.school_id
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/9kFEj.png" rel="nofollow noreferrer">My table that I have</a></p>
  
  <p>And this is what I'm trying to get. </p>
  
  <p><a href="https://i.stack.imgur.com/Rpawq.png" rel="nofollow noreferrer">This is the table I'm trying to get</a></p>
  
  <p>Is this possible? </p>