Uber | SQL Interview Question | Find the trip-gap
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- Ready to ace your Uber SQL interview? In this video, we'll dive deep into the most commonly asked SQL interview questions at Uber. Detailed explanations, practical examples, and real-world scenarios to help you solve business problems like a pro. Don't miss our expert tips on what Uber looks for in a candidate! If you find this video helpful, please like, comment, and subscribe for more tech interview prep content.
Data Schema & Create Table Query:
docs.google.co...
#Uber #SQLInterviewQuestions #DataScienceInterview #SQLTutorial #TechInterviews #UberDataScience #SQLPractice #InterviewPrep #CodingInterviews #DataEngineering
select rider_id,datediff(max(trip_date),min(trip_date)) as total_days
from trips
group by 1
having total_days>=2;
This will give the difference between the first and last trip, not the first and second trip