HackerRank SQL 1

SUBMITTED BY: ochlesis

DATE: Aug. 18, 2020, 6:19 a.m.

UPDATED: Aug. 18, 2020, 11:16 p.m.

FORMAT: Text only

SIZE: 146 Bytes

History Raw Download

HITS: 768

Report

SELECT ID,
       NAME,
       POPULATION,
       DISTRICT,
       COUNTRYCODE
FROM CITY
WHERE COUNTRYCODE = 'USA'
AND POPULATION > 100000;