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

Leetcode SQL

197. Rising Temperature

Table: Weather

+---------------+---------+
| Column Name   | Type    |
+---------------+---------+
| id            | int     |
| recordDate    | date    |
| temperature   | int     |
+---------------+---------+
id is the primary…

HackerRank SQL

Weather Observation Station 5

Leetcode SQL

569. Median Employee Salary

The Employee table holds all employees. The employee table has three columns: Employee Id, Company Name, and Salary.

+-----+------------+--------+
|Id   | Company    | Salary |
+-----+------------+--------+
|1    | A…

Leetcode SQL

1484. Group Sold Products By The Date

Table Activities:

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| sell_date   | date    |
| product     | varchar |
+-------------+---------+
There is no primary key for this table, it…

Leetcode SQL

585. Investments in 2016

Write a query to print the sum of all total investment values in 2016 (TIV_2016), to a scale of 2 decimal places, for all policy holders who meet the following criteria:

1. Have the same TIV_2015 value as one or more other…

Leetcode SQL

579. Find Cumulative Salary of an Employee

The Employee table holds the salary information in a year.

Write a SQL to get the cumulative sum of an employee’s salary over a period of 3 months but exclude the most recent month.