https://www.hackerrank.com/challenges/weather-observation-station-8/problem Weather Observation Station 8 | HackerRank Query CITY names that start AND end with vowels. www.hackerrank.com SELECT DISTINCT(CITY) FROM Station WHERE LEFT(CITY,1) in ('a','e','i','o','u') AND RIGHT(CITY,1) in ('a','e','i','o','u');

https://www.hackerrank.com/challenges/weather-observation-station-6/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com select DISTINCT CITY FROM STATION where LEFT(CITY,1) in ('a', 'e', 'i', 'o', 'u');

https://www.hackerrank.com/challenges/weather-observation-station-5/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com select CITY, LENGTH(CITY) from STATION ORDER BY LENGTH(CITY), CITY LIMIT 1; select CITY, LENGTH(CITY..

https://www.hackerrank.com/challenges/weather-observation-station-4/problem?h_r=next-challenge&h_v=zen Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com select count(*) - count(DISTINCT CITY) from STATION;

https://www.hackerrank.com/challenges/weather-observation-station-3/problem Weather Observation Station 3 | HackerRank Query a list of unique CITY names with even ID numbers. www.hackerrank.com SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0;

https://www.hackerrank.com/challenges/weather-observation-station-1/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com select CITY, ST..

https://www.hackerrank.com/challenges/japanese-cities-name/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen Japanese Cities' Names | HackerRank In this challenge, you will query a list of all the Japanese cities' names. www.hackerrank.com select name from city where countrycode = 'JPN';

https://www.hackerrank.com/challenges/revising-the-select-query-2/problem Revising the Select Query II | HackerRank Query the city names for all American cities with populations larger than 120,000. www.hackerrank.com select NAME from CITY where POPULATION > 120000 and COUNTRYCODE = 'USA'