select and count based on a condition
You can use a CASE expression inside the COUNT aggregate funciton.

SELECT
    COUNT( CASE WHEN position &gt; 1 THEN key_id ELSE NULL END ) AS GT1,
    COUNT( CASE WHEN position &gt; 2 AND position &lt; 5 THEN key_id ELSE NULL END ) AS GT2LT5,
FROM
     proj_reports


The COUNT aggregate does not count NULL values, so that's why it works. 

Here is a SQL Fiddle that demonstrates the concept.