title: SQL Multiple select count statements in one query
body: <p>I have data with no relation. Just need to count various columns from 3 tables and display them on the page as a view.</p>
  
  <p>This is the code so far but doesn't work:</p>
  
  <pre><code>SELECT COUNT(cars) AS A,
         (SELECT COUNT(boats) FROM tableBoats) AS B,
         (SELECT COUNT(trees) FROM tableTrees) AS C,
   FROM tableCars
  </code></pre>