Leetcode Problem 262. Trips and Users

262. Trips and Users

Leetcode Solutions

Calculating Cancellation Rate Using SQL Joins and Aggregation

Perform a LEFT JOIN of the Trips table with the Users table on client_id to get client information.
Perform another LEFT JOIN of the result with the Users table on driver_id to get driver information.
Use a WHERE clause to filter out trips with banned clients or drivers and to consider only trips within the specified date range.
Group the results by the request_at date.
Calculate the cancellation rate by dividing the count of cancelled trips by the total number of trips for each day, and round the result to two decimal places.
Select the request_at date and the calculated cancellation rate in the final output.

erDiagram
    Users {
        int users_id
        enum banned
        enum role
    }
    Trips {
        int id
        int client_id
        int driver_id
        int city_id
        enum status
        date request_at
    }
    Users ||--o{ Trips : "client_id"
    Users ||--o{ Trips : "driver_id"

Calculating Cancellation Rate Using Subqueries and Conditional Aggregation

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 262. Trips and Users

Leetcode Solutions

Calculating Cancellation Rate Using SQL Joins and Aggregation

Solution Idea

Query Steps

Code Implementation

Calculating Cancellation Rate Using Subqueries and Conditional Aggregation

Ask Question

Suggested Answer