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
Смотрите видео SQL Interview Questions And Answers Part 50 | WALMART SQL Interview Question And Answer онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ItJunction4all 11 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 4,609 раз и оно понравилось 82 людям.