Algorithm
Problem Name: Sql -
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