shantanubiswas93

Q5. There are two tables with the following details:

Ride_details table:

Ride_id – A unique entry for each ride taken. Created_at – The time on which the ride was created. Pickup_location – An id for the pickup location.

Drop_location – An id for the drop location.

Location table:

Location_id – A unique entry for each location.

Metro_location – 1 implies that the stand is a metro station. 0 implies that the stand is not a metro station.

Write an SQL query to get the date wise number of rides in the following sets -

1. Rides starting from the metro and ending at a non-metro location - Column name – metro_start

1. Rides starting from a non-metro location and ending at the metro station - Column name –

metro_end

1. Rides starting and ending at the metro station - Column name – metro_start_end

Rides starting and ending at a non-metro location - Column name – non_metro_start_end

There is a region table with the following columns:
Ride_id – A unique entry for each ride taken.
Created_at – The time on which the ride was created.
Region_name – The region in which the ride happened.
fraud_ride - binary column (1 for fraud rides and 0 for genuine rides)
Write an SQL query to get the region name with the overall third highest number of genuine_rides.

There is a region table with the following columns:

Ride_id – A unique entry for each ride taken. Created_at – The time on which the ride was created. Region_name – The region in which the ride happened.

Fraud_ride – binary column (1 for fraud rides and 0 for genuine rides)

Write an SQL query to get the region name with the overall third highest number of genuine_rides.