title: MySQL Query for total
body: <p>I have three tables 
  <a href="https://i.stack.imgur.com/1fx1J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1fx1J.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/kTrz3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kTrz3.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/wQ5P7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wQ5P7.png" alt="enter image description here"></a></p>
  
  <p>I have executed this query: </p>
  
  <pre><code>SELECT 
  `tbl_players`.`id` AS `player_id`
  ,`tbl_players`.`player_name`
  ,`tbl_sports`.`sports_name`
  ,`tbl_scores`.`score`
  FROM `tbl_players`
  LEFT JOIN `tbl_scores` ON `tbl_players`.`id`=`tbl_scores`.`player_id`
  LEFT JOIN `tbl_sports` ON `tbl_players`.`sports_id`=`tbl_sports`.`sports_id`
  ORDER BY `tbl_players`.`id` ASC
  </code></pre>
  
  <p>And I got this: 
  <a href="https://i.stack.imgur.com/ZxALK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZxALK.png" alt="enter image description here"></a></p>
  
  <p>Now I want this: 
  <a href="https://i.stack.imgur.com/oTkET.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oTkET.png" alt="enter image description here"></a></p>