title: How to get sum of records of female candidate whose age is less than 50 using MySQL query
body: <p>I have two table Candidates and Results and I also attached the screen shots of these two tables I want to get sum of votes of Female candidates whose age is less than 50.</p>
  <p>I am a bit new to databases.</p>
  <p>[<img src="https://i.stack.imgur.com/UBJ8o.png" alt="Results Table][1]" /></p>
  <p>And this is candidates table:</p>
  <p><a href="https://i.stack.imgur.com/UBJ8o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UBJ8o.png" alt="enter image description here" /></a></p>
  <pre><code> SELECT Results.candidate_id, Candidates.gender, Candidates.age, 
    FROM Results
    INNER JOIN Candidates
    ON Results.candidate_id=Candidates.id;
  
      
  </code></pre>