FIND NUMBER OF ITEMS IN A COLUMN SQL code example

Example: find number of entries sql

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