Returns the number of rows that are associated with the field:
SELECT priority FROM Case WHERE Priority ='High'
SELECT COUNT() FROM Case WHERE Priority ='High'
OR
SELECT COUNT(Priority) FROM Case WHERE Priority ='High'
SELECT COUNT(Id) FROM Account WHERE Name LIKE 'g%'