title: Average price with categories SQL query
body: <p>I currently have a table called Book which has the following fields</p>
  
  <pre><code>BOOK
  BOOK_CODE
  TITLE
  TYPE
  </code></pre>
  
  <p>There are many options within TYPE, eg SFI,FIC,MYS</p>
  
  <p>I need a query that shows the average price for each option</p>
  
  <p>currently have this but its just showing the average price of all the books:</p>
  
  <pre><code>SELECT AVG(PRICE) FROM BOOK
  WHERE TYPE IN ('SFI','MYS','ART','FIC');
  </code></pre>
  
  <p>Thanks in advance,</p>