SELECT * FROM city WHERE countrycode = "usa" AND population > 100000; note: 1. Use "Lower case" for city, countrycode, population. 2. And for the statement , clause and operator use "Upper Case".

note2: I have done upper query in mysql and it accepted double quotes for countrycode which is usa. But in case you happen to use any other language use single quote.

It looks like you're referencing a learning or practice module—possibly from a platform like HackerRank, W3Schools, or a course management system—with stages like:

Prepare

Certify

Compete

Search

And you're currently in:

Prepare > SQL > Basic Select > Revising the Select Query I

Would you like help with the “Revising the Select Query I” problem?

If so, please paste the problem statement, and I can help you write or correct the SQL query.

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

Error msg : Msg 2714, Level 16, State 6, Server dbrank-tsql, Line 3

There is already an object named 'CITY' in the database.


     can any help me out?

For this challenge, we must:

Select all columns using the all-column wildcard (*). Restrict the selected rows using the WHERE clause so that only records satisfying both of the following two conditions are returned: COUNTRYCODE is USA, meaning the cities are American. POPULATION is greater than 100000. You can read more about SELECT and WHERE in Oracle's documentation n