Algorithm


Problem Name: Sql - Revising the Select Query II

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

In this HackerRank Functions in SQL problem solution,

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

The CITY table is described as follows:
CITY.jpg

 

 

 

Code Examples

#1 Code Example with SQL

Code - SQL


-- github.com/RodneyShag

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

Demonstration


Previous
[Solved] Grading Students in SQL solution in Hackerrank
Next
[Solved] Select All in SQL solution in Hackerrank