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

Опубликовано: 20 Октябрь 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 [email protected]

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!" 🚀