Posts
기록
Cancel

Weather Observation Station 10 URL : https://www.hackerrank.com/challenges/weather-observation-station-10/problem Query the list of CITY names from STATION that do not end with vowels. Your r...

Weather Observation Station 1 URL : https://www.hackerrank.com/challenges/weather-observation-station-1/problem Query a list of CITY and STATE from the STATION table. MySQL, Oracle Solution...

Type of Triangle URL : https://www.hackerrank.com/challenges/what-type-of-triangle/problem Write a query identifying the type of each record in the TRIANGLES table using its three side length...

Top Earners URL : https://www.hackerrank.com/challenges/earnings-of-employees/problem We define an employee’s total earnings to be their monthly salary * months worked, and the maximum total ...

The PADS URL : https://www.hackerrank.com/challenges/the-pads/problem Generate the following two result sets: Query an alphabetically ordered list of all names in OCCUPATIONS, immediately f...

The Blunder URL : https://www.hackerrank.com/challenges/the-blunder/problem Samantha was tasked with calculating the average monthly salaries for all employees in the EMPLOYEES table, but did...

Select By ID URL : https://www.hackerrank.com/challenges/select-by-id/problem Query all columns for a city in CITY with the ID 1661. MySQL, Oracle Solution SELECT * FROM city WHERE id = ...

Select All URL : https://www.hackerrank.com/challenges/select-all-sql/problem Query all columns (attributes) for every row in the CITY table MySQL, Oracle Solution SELECT * FROM city

Revising the Select Query II URL : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem Query the NAME field for all American cities in the CITY table with populations la...

Revising the Select Query I URL : https://www.hackerrank.com/challenges/revising-the-select-query/problem Query all columns for all American cities in the CITY table with populations larger t...