I have a query that is giving me the results I am looking for (across multiple tables), however now I need to perform a count() on one column (table.FIRSTQPRI) to give me the result of the 5 categories that can be chosen (1,2,3,4,NULL)

Is there anyway I can keep my existing query and results and add a new column that will give me a count result on (table.FIRSTQPRI) without affecting the original query result?

Thanks
Nelson