count in sql and diff code example Example: count in sql and diff select (count(city)-count(distinct city)) from station;