Revising the Select Query II

Sort by

recency

|

673 Discussions

|

  • + 0 comments

    SELECT NAME FROM CITY WHERE population>120000 AND CountryCode="USA"

  • + 0 comments

    This worked but before this previous question doesn't worked

  • + 0 comments

    SELECT * FROM CITY WHERE CountryCode = 'USA' AND Population > 120000;

  • + 0 comments

    SELECT NAME FROM CITY WHERE POPULATION>120000 AND COUNTRYCODE='USA';

  • + 0 comments

    SELECT NAME FROM CITY WHERE CountryCode = 'USA' AND POPULATION > 120000;