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

ความคิดเห็น • 2

  • @pradeepvadlakonda007
    @pradeepvadlakonda007 3 หลายเดือนก่อน +1

    select rider_id,datediff(max(trip_date),min(trip_date)) as total_days
    from trips
    group by 1
    having total_days>=2;

    • @ashirrkashyap3849
      @ashirrkashyap3849  3 หลายเดือนก่อน

      This will give the difference between the first and last trip, not the first and second trip