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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 4
  5. Discussions

Weather Observation Station 4

Sort by

recency

|

1431 Discussions

|

  • shukla12798
     + 0 comments

    select count(*)-count(distinct(city)) from station

  • rakshanshetty16
     + 0 comments

    SELECT COUNT(CITY)-COUNT(DISTINCT(CITY)) FROM STATION;

  • jithinam530
     + 0 comments
    SELECT (COUNT(CITY)) - (COUNT(DISTINCT CITY)) FROM STATION;

  • onealdionte
     + 4 comments

    Has anyone gotten this correct? Every answer that I have seen, I used and still getting an error.

  • anubhav004
     + 0 comments

    select (count(city)-count(distinct(city))) from station;