Return to JUNTO

JUNTO Practice: Hackerrank, "Revising the Select Query 1"

Discussed on June 25, 2019.

Hackerrank, "Revising the Select Query 1"

Solutions

Click to see:

Oscar Martinez

SELECT *
FROM CITY
WHERE COUNTRYCODE = 'USA'
AND POPULATION > 100000;

John Lekberg

SELECT *
  FROM City
 WHERE population > 100000
       AND countrycode = 'USA'
;

Daniel Bassett

SELECT *
FROM CITY 
WHERE COUNTRYCODE = 'USA'
AND POPULATION > 100000;