SQL Interview Questions And Answers Part 50 | WALMART SQL Interview Question And Answer
SQL Interview Questions and answers Part 50 | WALMART SQL Interview Question And Answer
This question has been asked in WALMART interview. This question will be helpful in cracking any SQL interview
Problem Statement : Write a SQL query to output the names of those students whose best friends got higher salary package than Student.
-------------------------------------------------------------------------
𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥
-------------------------------------------------------------------------
*Instagram :
/ itjunction4all
*Twitter:
/ sunilkr5672
-------------------------------------------------------------------------
Table and Insert SQL Script :
-------------------------------------------------------------------------
Create Table Students_Tbl
(
Id int,
Student_Name Varchar(30)
)
Insert into Students_Tbl values(1,'Mark');
Insert into Students_Tbl values(2,'David');
Insert into Students_Tbl values(3,'John');
Insert into Students_Tbl values(4,'Albert');
Create Table Friends_Tbl(
Id int,
Friend_Id int
)
Insert into Friends_Tbl values(1,2);
Insert into Friends_Tbl values(2,3);
Insert into Friends_Tbl values(3,4);
Insert into Friends_Tbl values(4,1);
Create Table Package_Tbl
(Id int,
Salary Bigint )
Insert into Package_Tbl values(1,18);
Insert into Package_Tbl values(2,12);
Insert into Package_Tbl values(3,13);
Insert into Package_Tbl values(4,15);
#WalmartSQLQuestions #WALMARTInterview #WALMARTSQLInterview #FAANG #SQLInterviewQuestionsandanswers #sqlInterviewQuestions #MAANG #sqlInterviewQuestionsForTesting
Watch video SQL Interview Questions And Answers Part 50 | WALMART SQL Interview Question And Answer online without registration, duration hours minute second in high quality. This video was added by user ItJunction4all 11 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,609 once and liked it 82 people.