John Lekberg


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

Discussed on 2019-06-25.

Hackerrank, "Revising the Select Query 1"


Solution - Daniel

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

Solution - John

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

Solution - Oscar

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