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

Publicado el: 07 agosto 2024
en el canal de: 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!" 🚀

En esta página del sitio puede ver el video en línea Complex SQL Interview Question || Customer Transaction Mode Analysis || Data Analyst SQL Interview de Duración hora minuto segunda en buena calidad , que subió el usuario Data Project Hub 07 agosto 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 2,468 veces y le gustó 71 a los espectadores. Disfruta viendo!

173,676

1.9K