Weather Observation Station 3 query in SQL – Hacker Rank Solution

  Problem Query a list of  CITY  names from  STATION  for cities that have an even  ID  number. Print the results in any order, but exclude ...

Read More

Weather Observation Station 1 query in SQL – Hacker Rank Solution

  Problem Query a list of  CITY  and  STATE  from the  STATION  table. The  STATION  table is described as follows: where  LAT_N  is the nor...

Read More

Japanese Cities’ Names query in SQL – Hacker Rank Solution

  Problem Query the names of all the Japanese cities in the  CITY  table. The  COUNTRYCODE  for Japan is  JPN . The  CITY  table is describe...

Read More

Japanese City’s Attributes query in SQL – Hacker Rank Solution

  Problem Query all attributes of every Japanese city in the  CITY  table. The  COUNTRYCODE  for Japan is  JPN . Input Format The  CITY  tab...

Read More

Select By ID query in SQL – Hacker Rank Solution

  Problem Query all columns for a city in  CITY  with the  ID 1661 . Input Format The  CITY  table is described as follows: Select By ID que...

Read More

Select All queary in SQL – Hacker Rank Solution

  Problem Query all columns (attributes) for every row in the  CITY  table. Input Format The  CITY  table is described as follows: Select Al...

Read More

Revising the Select Query II – Hacker Rank Solution

  Problem Query the names of all American cities in  CITY  with populations larger than  120000 . The  CountryCode  for America is  USA . In...

Read More

Revising the Select Query I – Hacker Rank Solution

  Problem Query all columns for all American cities in  CITY  with populations larger than  100000 . The  CountryCode  for America is  USA ....

Read More