HackerRank SQL

The PADS

Generate the following two result sets:

1. Query an alphabetically…

HackerRank SQL

The Blunder

Samantha was tasked with calculating the average monthly salaries for all employees in…

HackerRank SQL

Top Earners

We define an employee’s total earnings to be their monthly salary* months worked, and…

HackerRank SQL

Binary Tree Nodes

HackerRank SQL

Weather Observation Station 5

HackerRank SQL

New Companies

Amber’s conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy:

Given the table schemas below, write a query to print the company_code, founder name, total number of lead…

HackerRank SQL

Type of Triangle

Write a query identifying the type of each record in the TRIANGLES table using…

HackerRank SQL

Average Population of Each Continent

HackerRank SQL

Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is ‘Africa’.

HackerRank SQL

Interviews

Samantha interviews many candidates from different colleges using coding challenges and…