HackerRank-SQL
The following repo contains solutions of Hackerrank SQL track.
Following all codes are written in MySQL.
Basic Select
- Revising the Select Query I
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';
- Revising the Select Query II
SELECT NAME FROM CITY WHERE COUNTRYCODE = 'USA' AND POPULATION > 120000;
- Select All
SELECT * FROM CITY;