Revising Aggregations - The Count Function

Sort by

recency

|

508 Discussions

|

  • + 0 comments

    whats wrong with hackerank? for every query its showing error message though I write correct query. can someone help me here?

  • + 0 comments

    SELECT count(*) FROM city WHERE population > 100000 ;

  • + 0 comments

    SELECT COUNT(*) FROM CITY WHERE population >100000;

  • + 0 comments

    SELECT COUNT(*) FROM CITY WHERE Population > 100000;

  • + 0 comments

    select count(COUNTRYCODE) from CITY where POPULATION > 100000;