Placements | HackerRank | MSSQL

The Problem

In this SQL problem, we're given three tables: Students, Friends, and Packages.

The Students table contains two columns:

• ID (the student's ID), and


• Name (the student's name).

The Friends table contains two columns:

• ID (the student's ID), and


• Friend_ID (ID of the ONLY best friend of the student).

The Packages table contains two columns:

• ID (the student's ID), and


• Salary (offered salary to the student, in $ thousands per month).

Here's a visual representation of these three tables: …

database friends hackerrank mssql name packages problem sql student students tables tutorial