Complex SQL Interview Question || Customer Transaction Mode Analysis || Data Analyst SQL Interview
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!" 🚀
Auf dieser Seite können Sie das Online-Video Complex SQL Interview Question || Customer Transaction Mode Analysis || Data Analyst SQL Interview mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Data Project Hub 07 August 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 2,468 Mal angesehen und es wurde von 71 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
