title: SQL: Fetching a table summary/statistics
body: <p>There is a table that I want to have several statistics(summary) on it. The table name is "jobs" and some of the needed statistics are:</p>
  
  <p>The number of jobs that are active, the number of jobs that are in inactive status, the number of jobs which need male force, the number of jobs which pay more than x amount per month, ...</p>
  
  <p>I need a query to pull all this statistics form the "jobs" table and put in into <strong>one-row</strong> result. Query result should look something like this:</p>
  
  <pre><code>+---------------+---------------+---------------+-----+
  | stats1_column | stats2_column | stats3_column | ... |
  +---------------+---------------+---------------+-----+
  | x             | y             | z             | ... |
  +---------------+---------------+---------------+-----+
  </code></pre>
  
  <p>After all, do you think I <strong>fetch table summary</strong> properly like what I'm doing? Or I'm wrong and there is a better way?</p>
  
  <p>I'm working on a PHP project using MySQL database.</p>