We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 4
Weather Observation Station 4
Sort by
recency
|
1265 Discussions
|
Please Login in order to post a comment
select count(City) - count(distinct (city)) from station;
SELECT (SELECT COUNT(CITY) FROM STATION) - (SELECT COUNT(DISTINCT CITY) FROM STATION) AS Difference;
CORRECT CODE
SELECT (COUNT(CITY) - COUNT(DISTINCT CITY) ) FROM STATION;
what is the correct code for this? I try the below codes and none of those correct
select count(CITY) -count( DISTINCT CITY) as new FROM STATION;