We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Revising the Select Query I
  5. Discussions

Revising the Select Query I

Sort by

recency

|

929 Discussions

|

  • subhojitnandy151
     + 0 comments

    SELECT * From CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA',

    This is my answer but when I run code it's said it's wrong.

  • sarusarathy200
     + 0 comments

    give a solution for this statement

  • baerrenvile3672
     + 0 comments

    "This problem is a good exercise for filtering data using the WHERE clause. Remember to pay attention to the instructions about avoiding the AS keyword and writing the query in a single line — small formatting details like these often cause errors even if your logic is correct."

  • markhale664
     + 3 comments

    Make sure to wrap 'USA' in single quotes — double quotes won’t work for string values in SQL. Found a quick guide that breaks this down clearly.

  • 11239a074
     + 0 comments

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