HackerRank SQL

The PADS

Generate the following two result sets:

1. Query an alphabetically…

HackerRank SQL

New Companies

Problem:

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…

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

Challenges

Problem:

Julia asked her students to create some coding challenges. Write a query to print the hacker_id, name, and the total number of challenges created by each student. Sort your results by the total number of challenges in…

HackerRank SQL

Higher Than 75 Marks

Problem:

HackerRank SQL

Top Competitors

Problem:

Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query to print the respective hacker_id and name of hackers who achieved full scores for more than…

HackerRank SQL

Interviews

Problem:

HackerRank

Ollivander’s Inventory

Problem: