Weather Observation Station 1- HackerRank SQL
Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and L…
Showing posts with the label sqlShow all
Japanese Cities' Names- HackerRank SQL
Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN . The CITY table is described as follows: exit:…
Japanese Cities' Attributes - HackerRank SQL
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN . The CITY table is described as follows: SE…
Select By ID- HackerRank SQL
Query all columns for a city in CITY with the ID 1661 . The CITY table is described as follows: xxxxxxxxxx 8 7 SELECT * FROM CITY 8 WHER…
Select All-SQL
rate this challenge Query all columns (attributes) for every row in the CITY table. The CITY table is described as follows: Fork …
Revising the Select Query II-SQL
rate this challenge Query the NAME field for all American cities in the CITY table with populations larger than 120000 . The CountryCode for Ameri…
Revising the Select Query I - SQL
Query all columns for all American cities in the CITY table with populations larger than 100000 . The CountryCode for America is USA . The CITY …
