HackerRank - SQL - Basic Select

hackerRank-SQL-basic-select.sql

/* Employee Salaries */
SELECT name FROM Employee WHERE months < 10 AND salary > 2000 ORDER BY employee_id ASC

/* Employee Names */
SELECT name FROM Employee ORDER BY name

/* Higher Than 75 Marks */
SELECT Name FROM STUDENTS WHERE Marks > 75 ORDER BY RIGHT(Name, 3), ID

/* Weather Observation Station 12 */
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U') AND LEFT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 11 */
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U') OR LEFT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 10 */
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 9 */
SELECT DISTINCT(CITY) FROM STATION WHERE LEFT(CITY, 1) NOT IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 8 */
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U') AND LEFT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 7 */
SELECT DISTINCT(CITY) FROM STATION WHERE RIGHT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 6 */
SELECT DISTINCT(CITY) FROM STATION WHERE LEFT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U')

/* Weather Observation Station 5 */
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1;
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1;

/* Weather Observation Station 4 */
SELECT COUNT(CITY)-COUNT(DISTINCT CITY) FROM STATION

/* Weather Observation Station 3 */
SELECT DISTINCT CITY FROM STATION WHERE ID%2 = 0

/* Weather Observation Station 1 */
SELECT CITY, STATE FROM STATION 

/* Japanese Cities' Names */
SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN"

/* Japanese Cities' Attributes */
SELECT * FROM CITY WHERE COUNTRYCODE = "JPN"

/* Select By ID */
SELECT * FROM CITY WHERE ID = 1661

/* Select All */
SELECT * FROM CITY

/* Revising the Select Query II */
SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = "USA";

/* Revising the Select Query I */
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';