Algorithm

Problem Name: Sql - Japanese Cities' Names

Problem Link: https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true

In this HackerRank Functions in SQL problem solution,

Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:

 

Code Examples

#1 Code Example with SQL

Code - SQL


SELECT NAME FROM CITY
WHERE COUNTRYCODE = 'JPN';
Copy The Code & Try With Live Editor
Advertisements

Demonstration

Previous
[Solved] Japanese Cities' Attributes in SQL solution in Hackerrank
Next
[Solved] Weather Observation Station 1 in SQL solution in Hackerrank