title: Having problems with SQL Joins
body: <p>Table <strong>A</strong></p>
  
  <p><img src="https://i.stack.imgur.com/UQtD4.png" alt="enter image description here"></p>
  
  <p>Table <strong>B</strong></p>
  
  <p><img src="https://i.stack.imgur.com/qYRCt.png" alt="enter image description here"></p>
  
  <p>I tried to use <code>LEFT OUTER JOIN</code> but it seems not working..</p>
  
  <p><img src="https://i.stack.imgur.com/BGou2.png" alt="enter image description here"></p>
  
  <p>I want the query to extract all data from Table A with 0 as average score if there is no data yet for the specified parameter. Meaning, in Figure 3, it should have shown ID 2 with 0 on s. Can anyone help me figure out the solution?</p>