CA30- Basic Hackerrank Queries

1.Select All
The Goal: Query all columns for every row in the CITY table.

![ ](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/x9izg30iwcgr03kjizj3.png

2.Select by ID
The Goal: Query all columns for a city in CITY with the ID 1661.

3.Revising the Select Query I
The Goal: Query all columns for American cities in CITY with populations larger than 100,000. The Country Code for America is USA

4.Revising the Select Query II
The Goal: Query the NAME field for all American cities with populations larger than 120,000.

5.Japanese Cities' Attributes
The Goal: Query all attributes of every Japanese city in the CITY table. The Country Code for Japan is JPN.

6.Japanese Cities' Names
The Goal: Query the names of all the Japanese cities in the CITY table.

7.Weather Observation Station 1
The Goal: Query a list of CITY and STATE from the STATION table.

8.Weather Observation Station 4
The Goal: Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.

9.Weather Observation Station 9
The Goal: Query the list of CITY names from STATION that do not start with vowels (a, e, i, o, u). Your result cannot contain duplicates.