www.hackerrank.com/challenges/the-pads/problem The PADS | HackerRank Query the name and abbreviated occupation for each person in OCCUPATIONS. www.hackerrank.com Generate the following two result sets: Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical (i.e.: enclosed in parentheses). For example: AnAct..

Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in the table: Equilateral: It's a triangle with 3sides of equal length. Isosceles: It's a triangle with 2sides of equal length. Scalene: It's a triangle with 3sides of differing lengths. Not A Triangle: The given values of A, B, and C don't..

www.hackerrank.com/challenges/name-of-employees/problem Employee Names | HackerRank Print employee names. www.hackerrank.com Answer select name from employee order by name www.hackerrank.com/challenges/salary-of-employees/problem Employee Salaries | HackerRank Print the names of employees who earn more than $2000 per month and have worked at the company for less than 10 months. www.hackerrank.co..

Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two or more students both have names ending in the same last three characters (i.e.: Bobby, Robby, etc.), secondary sort them by ascending ID. Input Format The STUDENTS table is described as follows: The Name column only contains uppercase (A-Z) and lowercase (a..

www.hackerrank.com/challenges/weather-observation-station-11/problem Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com Answer select distinct city from station where city not regexp '^[aeiou]' or city not regexp '[aeiou]$' www.hackerrank.com/challenges/weather-observation-station-12/problem Weather Observation Station 12..

www.hackerrank.com/challenges/weather-observation-station-9/problem Weather Observation Station 9 | HackerRank Query an alphabetically ordered list of CITY names not starting with vowels. www.hackerrank.com Answer select distinct city from station where city not regexp '^[aeiou]' ~로 시작하지 않는 것을 나타낼때는 'NOT'를 사용한다. www.hackerrank.com/challenges/weather-observation-station-10/problem Weather Observa..

www.hackerrank.com/challenges/weather-observation-station-7/problem Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com Answer select distinct city from station where city regexp '[aeiou]$' 정규표현식에서 ~로 끝나는 것을 나타내는 것은 '$'이다. www.hackerrank.com/challenges/weather-observation-station-8/problem Weather Observation..

www.hackerrank.com/challenges/weather-observation-station-5/problem 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 Answer select city, length(city) from station order by length(city), city limit 1; select city, length(city) from station order by length(city) desc, city limit 1..

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 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 th..

www.hackerrank.com/challenges/weather-observation-station-1/problem Weather Observation Station 1 | HackerRank Write a query to print the CITY and STATE for each attribute in the STATION table. www.hackerrank.com Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Answer select..