sql number of entries code example

Example: find number of entries sql

Select  count(CITY) - count(DISTINCT CITY) 
from tablename