UBER Interview Question | SQL Interview Question no 17 | Daily SQL Practice | Advanced SQL
In this Question we have two table named users and friends. fro those tables we need to find the common friends of particular two users named: hans and karl. please watch the video for more details
.
.
.
.
#SQL #SQLInterviewQuestions #LearnSQL #DataAnalysis #SQLQuery #InterviewTips #Database #programming
.
.
.
.
-----------------------Table Script---------------------------------------
CREATE TABLE users(user_id INT, user_name varchar(30));
INSERT INTO users VALUES
(1, 'Karl'),
(2, 'Hans'),
(3, 'Emma'),
(4, 'Emma'),
(5, 'Mike'),
(6, 'Lucas'),
(7, 'Sarah'),
(8, 'Lucas'),
(9, 'Anna'),
(10, 'John');
CREATE TABLE friends(user_id INT, friend_id INT);
INSERT INTO friends VALUES (1,3),
(1,5),
(2,3),
(2,4),
(3,1),
(3,2),
(3,6),
(4,7),
(5,8),
(6,9),
(7,10),
(8,6),
(9,10),
(10,7),
(10,9);
On this page of the site you can watch the video online UBER Interview Question | SQL Interview Question no 17 | Daily SQL Practice | Advanced SQL with a duration of hours minute second in good quality, which was uploaded by the user The Data -Tech Club 30 October 2024, share the link with friends and acquaintances, this video has already been watched 454 times on youtube and it was liked by 17 viewers. Enjoy your viewing!
