Problem Statement A description of the problem can be found on Hackerrank. Solution Select only Names and filter by CountryCode equals to ‘JPN’. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 |
select Name from City where CountryCode = 'JPN'; |
Problem Statement A description of the problem can be found on Hackerrank. Solution The difference between Revising the Select Query – 1 is that you select only name column and filter by same conditions, only the population number is higher. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 2 |
Select name from City where CountryCode='USA' and population > 120000; |
Problem Statement A description of the problem can be found on Hackerrank. Solution Select all columns and filter by CountryCode and Population. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 2 |
Select name from City where CountryCode='USA' and population > 120000; |
Problem Statement A description of the problem can be found on Hackerrank. Solution Simple. Just select all rows and columns. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 |
select * from City; |
Problem Statement A description of the problem can be found on Hackerrank. Solution Select all rows and filter by value if ID column equals to 1661. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 |
select * from City where ID = 1661; |
Problem Statement A description of the problem can be found on Hackerrank. Solution Select City, State and then order first by city ascending and then state ascending. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 |
select city, state from station order by city asc, state asc; |
Problem Statement A description of the problem can be found on Hackerrank. Solution Select cities then filter if ID modulo 2 equals to 0 and order alphabetically ascending. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 2 3 4 5 |
select distinct city from station where MOD(id, 2) = 0 order by city asc; |
Problem Statement A description of the problem can be found on Hackerrank. Solution In a subselect selects count of all cities and unique cities and then substract these numbers. I created solution in: SQL All solutions are also available on my GitHub. SQL
|
1 2 3 4 5 |
select num - num_uniq from ( select count(city) as num, count(distinct city) as num_uniq from station ); |