nested select count sql code example Example: get substract count sql select Count(City) - Count(Distinct(City)) from Station;