Posted on June 5, 2020June 5, 2020 Description Submission select count(city) - count(distinct(city)) from station; References https://www.w3resource.com/mysql/aggregate-functions-and-grouping/aggregate-functions-and-grouping-count-with-distinct.php By Bill0412 SQL