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. Practice
  2. SQL
  3. Basic Select
  4. Japanese Cities' Attributes
  5. Discussions

Japanese Cities' Attributes

Sort 71 Discussions, By:

votes

  • ldai100 + 1 comment

    isn't this a repeat of the previous challenge?

    • shivashettyswat2 + 0 comments

      select * from city where COUNTRYCODE='JPN';

  • yosefvb + 0 comments
    SELECT * FROM CITY
WHERE COUNTRYCODE = 'JPN';

    Remember to use single quotes here. It is best practice to use single quotes ('JPN') in SQL, even though double quotes ("JPN") will work in MySQL.

  • seniakinbolajo + 0 comments

    SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';

  • sumit32816 + 0 comments

    SELECT* FROM CITY WHERE COUNTRYCODE IN'JPN';

  • naveenvelu0741 + 0 comments

    SELECT NAME FROM CITY WHERE COUNTRYCODE= 'JPN

    THIS CODE IS NOT CORRECT EXECUTE

Load more conversations