title: Combining multiple SELECT queries in one
body: <p>As the title says the query needs to combine multiple select queries. The question is as follows:</p>
  
  <p><strong>Display the total number of employees, and of that total the number of employees hired in 1995,1996,1997,1998.</strong></p>
  
  <p>My query: </p>
  
  <pre><code>select (select count(*) from employees) as "Total",
         (select count(*) from employees where hire_date between 'JAN-1-0095' and 'DEC-1-0095')as "1995",
         (select count(*) from employees where hire_date between 'JAN-1-0096' and 'DEC-1-0096') as "1996",
         (select count(*) from employees where hire_date between 'JAN-1-0097' and 'DEC-1-0097') as "1997",
         (select count(*) from employees where hire_date between 'JAN-1-0098' and 'DEC-1-0098') as "1998" 
  from employees
  </code></pre>
  
  <p>but the issue is instead of returning only single record this query is being executed for all the records in the table and hence producing the following output:</p>
  
  <p><a href="https://i.stack.imgur.com/6QZD0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6QZD0.png" alt="enter image description here"></a></p>