mysql count help

Question

I am trying to count the number of rows in a table that have an area, how can I achieve this, I currently have this query written,

SELECT DISTINCT area 
  FROM cv 
 WHERE status = 'SHOW' 
   AND is_complete = 'TRUE' 
ORDER BY area ASC

This query currently returns,

area
------------------
West Yorkshire  
Lanchashire  

What I am wanting is something like,

area             Number
------------------------
West Yorkshire   19000  
Lancashire       7000

Answer 1

select area, count(*)
from cv
where status = 'SHOW' 
    and is_complete = 'TRUE' 
group by area

Answer 2

SELECT area, COUNT(area)
  FROM cv
WHERE status = 'SHOW'
  AND is_complete = 'TRUE'
  AND area IS NOT NULL
GROUP BY area

Answer 3

SELECT area, COUNT(area)
  FROM cv
WHERE status = 'SHOW'
  AND is_complete = 'TRUE'
GROUP BY area

Count of area will count only non null values

Answer 4

The sql distinct will list only the diffent values in a table, you original query will need to have count() and group by as well:

SELECT DISTINCT area, count(*) 
  FROM cv
.....

group by area

alternatively, Red Filer and gkrogers answer is good as well.