Sql

Leetcode SQL

262. Trips and Users

Table: Trips

+-------------+----------+
| Column Name | Type     |
+-------------+----------+
| Id          | int      |
| Client_Id   | int      |
| Driver_Id   | int      |
| City_Id     | int      |
| Status      | enum     |
|…

HackerRank SQL

Interviews

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

HackerRank SQL

Top Earners

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

HackerRank SQL

The Blunder

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

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

Binary Tree Nodes

HackerRank SQL

The PADS

Generate the following two result sets:

1. Query an alphabetically…

HackerRank SQL

Type of Triangle

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

HackerRank SQL

Weather Observation Station 5

HackerRank SQL

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