title: Multiply total number of values in column by value in a different table
body: <p>I am trying to count all the values in one column and then multiply this number by a value in a different table. So far I have:</p>
  
  <pre><code>SELECT CLUB_FEE * COUNT(MEMBER_ID) AS VALUE
  FROM CLUB, SUBSCRIPTION
  WHERE CLUB_ID = 'CLUB1';
  </code></pre>
  
  <p>This is not working however, can anyone please help?</p>
  
  <p>I also need help doing this for multiple clubs. Is it possible to do it all in one statement for all clubs and then get the average?</p>