John Doe

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit .
Erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper.

3066 Stone Lane, Wayne, Pennsylvania.

+610-401-6021, +610-401-6022

admin@mydomain.com

www.yourdomain.com

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

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

select distinct city from station where MOD(STATION.ID,2)=0

and if we have to print in order then

SELECT DISTINCT CITY FROM STATION WHERE MOD(STATION.ID,2)=0 ORDER BY CITY;

Query a list of CITY and STATE from the STATION table.

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

select city , state from station;

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

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:

SELECT name from CITY where COUNTRYCODE= 'JPN';

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

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is `JPN`.

The CITY table is described as follows:

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is `JPN`.

select * from city where countrycode = 'JPN';

Query all columns for a city in CITY with the ID 1661.Hackerrank SQL

Query all columns for a city in CITY with the ID `1661`.

The CITY table is described as follows:

select * from city where ID= 1661

Query all columns (attributes) for every row in the CITY table. Hacker Rank Solution

Query all columns (attributes) for every row in the CITY table.

The CITY table is described as follows:

Query all columns (attributes) for every row in the CITY table.

Hi, I am

Mahipal Thakur

ABOUT ME

John Doe

My Professional Skills

Services

Awesome features

Animated elements

Responsive Design

Modern design

Retina ready

Fast support

Portfolio