Revising the Select Query I

Sort by

recency

|

908 Discussions

|

  • + 0 comments

    For MySQL Platform

    SELECT * FROM city
    WHERE countrycode = "USA" and population > 100000;
    
  • + 0 comments

    cant be able to submit the code

  • + 1 comment

    cant submit the code server issue or what?

  • + 0 comments

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

  • + 0 comments

    You just need to select all columns from CITY where CountryCode = 'USA' and Population > 100000. Works fine.