Tricky SQL Interview Question || Window Function || Case Statement || Data Analyst SQL Interview

Veröffentlicht am: 18 Juni 2024
auf dem Kanal: Data Project Hub

620

In this video we will solve a SQL interview question which was asked in multiple companies for data related roles.

Question :-

Write a SQL to display the Source_Phone_Nbr and a flag where the flag needs to be set to 'Y' if first called number and last called number are the same and 'N' if first called number and last called number are different.

Table Script :-

create table phone_log(
source_phone_nbr int, destination_phone_nbr int,
call_start_date_time datetime)

insert into phone_log
values(2345,6789,'2099-07-01 10:00:00'),
(2345,1234,'2099-07-01 11:00:00'),
(2345,4567,'2099-07-01 12:00:00'),
(2345,4567,'2099-07-01 13:00:00'),
(2345,6789,'2099-07-01 15:00:00'),
(3311,7890,'2099-07-01 10:00:00'),
(3311,6543,'2099-07-01 12:00:00'),
(3311,1234,'2099-07-01 13:00:00')

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

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

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

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

✅Learn SQL Concepts
   • SQL Fundamentals: Key Concepts and Skills

✅SQL Functions
   • SQL Functions Explained: Practical Uses an...

📩 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 Tricky SQL Interview Question || Window Function || Case Statement || Data Analyst SQL Interview mit der Dauer online in guter Qualität ansehen, das der Benutzer Data Project Hub 18 Juni 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 620 Mal angesehen und es wurde von like den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

18,715

849