Skip to content
Programming101
Programmingoneonone

Learn everything about programming

  • Home
  • CS Subjects
    • IoT – Internet of Things
    • Digital Communication
    • Human Values
  • Programming Tutorials
    • C Programming
    • Data structures and Algorithms
    • 100+ Java Programs
    • 100+ C Programs
  • HackerRank Solutions
    • HackerRank Algorithms Solutions
    • HackerRank C problems solutions
    • HackerRank C++ problems solutions
    • HackerRank Java problems solutions
    • HackerRank Python problems solutions
Programming101
Programmingoneonone

Learn everything about programming

Leetcode Trips and Users problem solution

YASH PAL, 31 July 2024

In this Leetcode Trips and Users problem solution Write a SQL query to find the cancellation rate of requests with unbanned users (both client and driver must not be banned) each day between “2013-10-01” and “2013-10-03”.

The cancellation rate is computed by dividing the number of canceled (by client or driver) requests with unbanned users by the total number of requests with unbanned users on that day.

Return the result table in any order. Round Cancellation Rate to two decimal points.

Leetcode Trips and Users problem solution

Topics we are covering

Toggle
  • Problem solution in MYSQL.
  • Problem solution in Oracle.

Problem solution in MYSQL.

select t.Request_at as Day,
        cast(sum(case when Status <> 'completed' then 1.00 else 0.00 end)/count(*) as decimal(10,2)) as 'Cancellation Rate'
from Trips as t
join Users as uc on t.Client_Id = uc.Users_Id and uc.Banned = 'No'
join Users as ud on t.Driver_id = ud.Users_Id and ud.Banned = 'No'
where t.Request_at between '2013-10-01' and '2013-10-03'
group by t.Request_at

Problem solution in Oracle.

select request_at Day,
round(sum(case when status ='cancelled_by_driver' or status = 'cancelled_by_client' then 1 else 0 end)/count(*),2) as "Cancellation Rate"
from trips
where request_at between '2013-10-01' and '2013-10-03'
and client_id not in (select users_id from users where banned ='Yes')
and driver_id not in (select users_id from users where Banned = 'Yes')
group by request_at
order by request_at;

coding problems solutions

Post navigation

Previous post
Next post
  • Automating Image Format Conversion with Python: A Complete Guide
  • HackerRank Separate the Numbers solution
  • How AI Is Revolutionizing Personalized Learning in Schools
  • GTA 5 is the Game of the Year for 2024 and 2025
  • Hackerrank Day 5 loops 30 days of code solution
How to download udemy paid courses for free

Pages

  • About US
  • Contact US
  • Privacy Policy

Programing Practice

  • C Programs
  • java Programs

HackerRank Solutions

  • C
  • C++
  • Java
  • Python
  • Algorithm

Other

  • Leetcode Solutions
  • Interview Preparation

Programming Tutorials

  • DSA
  • C

CS Subjects

  • Digital Communication
  • Human Values
  • Internet Of Things
  • YouTube
  • LinkedIn
  • Facebook
  • Pinterest
  • Instagram
©2025 Programmingoneonone | WordPress Theme by SuperbThemes