SELECT category, COUNT(*) AS count FROM your_table WHERE (field1 - field2) = 1 GROUP BY category;SELECT category, COUNT(*) AS count FROM your_table WHERE (field1 - field2) = 1 GROUP BY category;SELECT category, COUNT(*) AS count FROM your_table WHERE (field1 - field2) = 1 GROUP BY category;