HackerRank SQL Preparation: Japanese Cities’ Attributes(MySQL)

HackerRank SQL Preparation: Japanese Cities’ Attributes(MySQL)

Problem Statement:
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

Link: HackerRank – Japanese Cities Attributes

Solution:

SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';
Enter fullscreen mode
Exit fullscreen mode

Explanation:

  • SELECT *: The asterisk (*) is a wildcard character in SQL that means “all columns.” This part of the query specifies that you want to retrieve all columns from the table.
  • FROM CITY: Indicates that you are selecting data from the CITY table.
  • WHERE COUNTRYCODE = 'JPN': This condition filters the rows to include only the cities where the COUNTRYCODE is ‘JPN’ (Japan).

This query will return all the columns for every row in the CITY table where the COUNTRYCODE is ‘JPN’. It’s useful when you need to retrieve all details about every city in Japan.

By running this query, you can see the complete dataset of Japanese cities stored in the CITY table, including information such as city names, populations, districts, and other relevant attributes.


Discover more from Coursity

Subscribe to get the latest posts to your email.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *