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!" 🚀
Sur cette page du site, vous pouvez voir la vidéo en ligne Complex SQL Interview Question || Customer Transaction Mode Analysis || Data Analyst SQL Interview durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Data Project Hub 07 août 2024, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 2,468 fois et il a aimé 71 téléspectateurs. Bon visionnage!
