Skip to main content

Find whose best friends got offered higher salary!

Problem Statement
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).

Write a query to output the names of those students whose best friends got offered a higher salary than them. Names must be ordered by the salary amount offered to the best friends. It is guaranteed that no two students got same salary offer.
Sample Input

Sample Output
Samantha
Julia
Scarlet

Explanation
See the following table:

Now,
·         Samantha's best friend got offered a higher salary than her at 11.55
·         Julia's best friend got offered a higher salary than her at 12.12
·         Scarlet's best friend got offered a higher salary than her at 15.2
·         Ashley's best friend did NOT get offered a higher salary than her
The name output, when ordered by the salary offered to their friends, will be:
·         Samantha
·         Julia
·         Scarlet

 Query:
--------------------------------------------------------------
Select    s.name,
from      students s,
                friends f,
                packages p1,
                packages p2
Where  p2.salary > p1.salary
                and p2.id = f.friend_id
                and p1.id = s.id
                and s.id = f.id

order by p2.salary;


Output:
--------------------------------------------------------------------
Congratulations, you passed this test case!
Your Output (stdout)
Stuart 
Priyanka 
Paige 
Jane 
Julia 
Belvet 
Amina 
Kristeen 
Scarlet 
Priya 
Meera

Comments

Post a Comment

Popular posts from this blog

Java Interface

Problem Statement A Java interface can only contain method signatures and fields. Interface can be used to achieve polymorphism. In this problem you will practice your knowledge on interfaces. You are given an interface   AdvancedArithmetic   which contains a method signature   public abstract int divisorSum(int n) . You need to write a class called MyCalculator which implements the interface. divisorSum   function just takes an integer as input and return the sum of all its divisors. For example divisors of 6 are 1,2,3 and 6, so   divisorSum   should return 12. Value of n will be at most 1000. Read the partially completed code in the editor and complete it. You just need to write the MyCalculator class only.   Your class shouldn't be public. Sample Input 6 Sample Output I implemented: AdvancedArithmetic 12 Explanation Divisors of 6 are 1,2,3 and 6. 1+2+3+6=12. import java.util.*; interface AdvancedArithmetic{   public abstract int divisorSum(int n
Post a Comment
Read more

Problem: Java Exception Handling

Problem Statement Create a class myCalculator which consists of a single method power(int,int). This method takes two integers,   n   and   p , as parameters and finds   n p . If either   n   or   p   is negative, then the method must throw an exception which says "n and p should be non-negative". Please read the partially completed code in the editor and complete it. Your code mustn't be public. No need to worry about constraints, there won't be any overflow if your code is correct. Sample Input 3 5 2 4 -1 -2 -1 3 Sample Output 243 16 java.lang.Exception: n and p should be non-negative java.lang.Exception: n and p should be non-negative import  java.util.*; class myCalculator{     int power(int n,int p) throws java.lang.Exception{         int power=1;         while(p>0){             power=power*(n);             p--;         }                 if(n==0) power=0;                if(n<0 | p<0){       
Post a Comment
Read more

Google Cloud Shell | Delete instance

Post a Comment
Read more