You are viewing a single comment's thread. Return to all comments →
DECLARE @CC AS INT = (SELECT COUNT(CITY) FROM STATION) DECLARE @CDC AS INT = (SELECT COUNT(DISTINCT CITY) FROM STATION); SELECT @CC - @CDC
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 4
You are viewing a single comment's thread. Return to all comments →
DECLARE @CC AS INT = (SELECT COUNT(CITY) FROM STATION) DECLARE @CDC AS INT = (SELECT COUNT(DISTINCT CITY) FROM STATION); SELECT @CC - @CDC