hackerRank.md

Hacker Rank SQL problems

Easy Problems

1. Select All

Query all columns (attributes) for every row in the CITY table.

The CITY table is described as follows:

Solution:

select
  *
from
  city;

2. Revising the Select Query I

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:

Solution:

select
  *
from
  city
where
  population > 100000
  and countrycode = 'USA';

...