Revising the Select Query I

Sort by

recency

|

891 Discussions

|

  • + 0 comments

    Select * From City Where CounTrycode = 'USA' and Population > 100000;

  • + 0 comments

    select*from City where population>100000 AND CountryCode = 'USA'

  • + 0 comments

    SELECT * FROM CITY WHERE [COUNTRYCODE] = 'USA' AND [POPULATION] > 100000;

  • + 0 comments

    Check for 2 things population and countrycode.

    SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';

  • + 0 comments

    Mines is still saying wrong

    SELECT * FROM CITY SELECT * FROM CITY WHERE POPULATION>100000 AND COUNTRYCODE="USA";