title: Trying to count the amounts of entrances of a certain type by separately
body: <p>I have a table called <code>posts</code> that it has a field called <code>forum_type_id</code>.</p>
  
  <p>And another table called <code>forum</code> that it has a field called <code>forum_type</code> and an <code>id</code>.</p>
  
  <p>the id's of the forum table represent the type that its using to relation with the <code>forum_type_id</code> from the <code>posts</code> table </p>
  
  <p>Now, in my DB.</p>
  
  <ul>
  <li><p>In posts I have 3  entries with the <code>forum_type_id = 2</code> (representing the type 2 of my forum table that is "Questions").</p></li>
  <li><p>2 entries with the <code>forum_type_id = 1</code> (representing the type 1 of my forum table that is "General")</p></li>
  </ul>
  
  <p>I'm trying to make a query that get the amounts of every "type" by separately </p>
  
  <p>I try something like this .</p>
  
  <pre><code>  SELECT DISTINCT
      (SELECT COUNT (*) FROM posts WHERE posts.forum_type_id = '1') AS generalCount,forum.id
      (SELECT COUNT(*) FROM posts WHERE posts.forum_type_id = '2') AS questionsCount, forum.id
  FROM forum;
  </code></pre>
  
  <p>I expect to get for this example </p>
  
  <p>generalCount = 2;</p>
  
  <p>questionsCount = 3;</p>
  
  <p>but it make a addition and returns me just 1 line with the 2 numbers added</p>