Complex SQL Interview Question || Customer Transaction Mode Analysis || Data Analyst SQL Interview

Опубликовано: 07 Август 2024
на канале: Data Project Hub

2,468

In this video we will solve two complex sql interview questions.

Table Script :-

Create Table Customer(
Customer_id int, Cus_name Varchar(30),
Age int, Gender Varchar(10),
App Varchar(30) )

Insert into Customer Values(1,'Amelia',23,'Female','gpay')
Insert into Customer Values(2,'William',16,'Male','phonepay')
Insert into Customer Values(3,'James',18,'Male','paytm')
Insert into Customer Values(4,'David',24,'Male','paytm')
Insert into Customer Values(5,'Ava',21,'Female','gpay')
Insert into Customer Values(6,'Sophia',31,'Female','paytm')
Insert into Customer Values(7,'Oliver',23,'Male','gpay')
Insert into Customer Values(8,'Harry',29,'Male',NULL)
Insert into Customer Values(9,'Issac',16,'Male','gpay')
Insert into Customer Values(10,'Jack',22,'Male','phonepay')

Create Table Transaction_Tbls (
Loc_name Varchar(30), Loc_id int,
Cus_id int, Amount_paid Bigint,
Trans_id int)

Insert into Transaction_Tbls Values ('Florida',100,1,78899,1000)
Insert into Transaction_Tbls Values ('Florida',100,2,55678,1001)
Insert into Transaction_Tbls Values ('Florida',100,3,27788,1002)
Insert into Transaction_Tbls Values ('Florida',100,4,65886,1003)
Insert into Transaction_Tbls Values ('Alaska',101,5,57757,1004)
Insert into Transaction_Tbls Values ('Alaska',101,6,34676,1005)
Insert into Transaction_Tbls Values ('Alaska',101,7,66837,1006)
Insert into Transaction_Tbls Values ('Alaska',101,8,77633,1007)
Insert into Transaction_Tbls Values ('Texas',102,9,98766,1008)
Insert into Transaction_Tbls Values ('Texas',102,10,45335,1009)

🔍 Looking for something specific? Check out my curated playlists.

✅Complex SQL Interview Questions
   • Complex SQL Interview Questions: Mast...

✅SQL Interview Questions
   • SQL Interview Bootcamp: Questions & P...

✅SQL Mastery Interview Prep
   • SQL Concepts: Detailed Interview Ques...

✅Learn SQL Concepts
   • SQL Fundamentals: Key Concepts and Sk...

✅SQL Functions
   • SQL Functions Explained: Practical Us...

📩 Contact: For any inquiries or collaborations, please email me at dataprojecthub@gmail.com

Don't forget to hit the subscribe button and ring the notification bell to never miss an update! Become a valued member of our passionate community and be part of the journey with me!

Thanks for watching, and see you in the next video!" 🚀

На этой странице сайта вы можете посмотреть видео онлайн Complex SQL Interview Question || Customer Transaction Mode Analysis || Data Analyst SQL Interview длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь Data Project Hub 07 Август 2024, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 2,468 раз и оно понравилось 71 зрителям. Приятного просмотра!

164