Algorithm


Problem Name: Sql - Revising the Select Query I

Problem Link: https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true

In this HackerRank Functions in SQL problem solution,

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

The CITY table is described as follows:

CITY

Field TYpe
ID NUMBER
NAME VARCHAR2(17)
COUNTRYCODE VARCHAR3
DISTRICT VARCHAR2
POPULATION NUMBER

 

 

Code Examples

#1 Code Example with SQL

Code - SQL


-- github.com/RodneyShag

SELECT * FROM CITY
WHERE COUNTRYCODE = 'USA' AND POPULATION > 100000;
Copy The Code & Try With Live Editor
Advertisements

Demonstration


Previous
[Solved] Between Two Sets in C++,Java, Python, PHP & C# solution in Hackerrank
Next
[Solved] Revising the Select Query II in SQL solution in Hackerrank