Yahoo India Web Search

Search results

  1. Placements in SQL | HackerRank Solution - CodingBroz. 1 Comment / HackerRank, HackerRank SQL / By CodeBros. Hello coders, today we are going to solve Placements HackerRank Solution in SQL. Table of Contents. Problem. You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name .

  2. HackerRank concepts & solutions. Contribute to BlakeBrown/HackerRank-Solutions development by creating an account on GitHub.

  3. Jul 6, 2023 · The Solution. Here, I present two SQL solutions with slightly different approaches. Each has its own strengths, weaknesses, and applicability. Direct Join Approach. The first source code uses direct JOIN operations to link the necessary data from all tables:

  4. Jul 25, 2020 · Placements. Problem: You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name. Friends contains two columns: ID and Friend_ID (ID of the ONLY best...

  5. Solution In SQL With Problem Explanation And Algorithm - THARUN1526/Placements-Sql-Hackerrank-solution

  6. 8 lines (8 loc) · 212 Bytes. Raw. --MySQL & MS SQL Server. SELECT s.Name. FROM Students s. JOIN Friends f ON s.ID = f.Friend_ID. JOIN Packages p1 ON s.ID = p1.ID. JOIN Packages p2 ON f.Friend_ID = p2.ID. WHERE p1.Salary < p2.Salary. ORDER BY p2.Salary; Solutions for all SQL challenges on HackerRank executed on MySQL and MS SQL Server.

  7. Jul 30, 2020 · #HackerRank #SQL #PlacementsThis video contains medium level problem on SQL in HackerRank.You can go through each and every problem solved in this channel f...

  8. www.hackerrank.com › challenges › placementsPlacements | HackerRank

    You are given three tables: Students, Friends and Packages. Students contains two columns: ID and Name. Friends contains two columns: ID and Friend_ID ( ID of the ONLY best friend). Packages contains two columns: ID and Salary (offered salary in $ thousands per month).

  9. Sep 16, 2023 · Scarlet. Solution with INNER JOIN (MySQL Query) SELECT a.name. FROM Students a. INNER JOIN Friends b ON a.ID = b.ID. INNER JOIN Packages c ON a.ID = c.ID. INNER JOIN Packages c2 ON...

  10. Write a query to output the names of those students whose best friends got offered a higher salary than them.

  1. People also search for