Posts
Data Include Me
Cancel

# Type of Triangle

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

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

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

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

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

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

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

# Revising Aggregations - The Sum Function

Revising Aggregations - The Sum Function URL : https://www.hackerrank.com/challenges/revising-aggregations-sum/problem Query the total population of all cities in CITY where District is Calif...

# Revising Aggregations - The Count Function

Revising Aggregations - The Count Function URL : https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem Query a count of the number of cities in CITY having a ...