Algorithm

Problem Name: Sql - Japanese Cities' Attributes

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

In this HackerRank Functions in SQL problem solution,

Query all attributes of every Japanese city 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 * FROM CITY
WHERE COUNTRYCODE = 'JPN';
Copy The Code & Try With Live Editor
Advertisements

Demonstration

Previous
[Solved] Select By ID in SQL solution in Hackerrank
Next
[Solved] Japanese Cities' Names in SQL solution in Hackerrank