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 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.
Rider_id – The rider who took the ride.
Rider table:
Rider_id – A unique entry for each rider.
Created_at – The time at which the rider was registered into the system.
Write one SQL query to find day wise details of the following:
1. The number of riders registered.
2. The number of riders who took a ride on the same day they were registered.
3. % of riders who took a ride on the same day they were registered.

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

33. Base10 is the set of numbers created from the digits {0,1,2,3,4,5,6,7,8,9}. Whereas base2, which is the set of numbers created with {0,1}. We could similarly define base; as the ordered set of characters created from {X,Y,Z}. What is the following basez number, Yxz, in base ? Random graph For this section you will need to look at the classes Graph and GraphNode present in the appendix. A Graph consists of a number of nodes, each of which has connections to other nodes in the graph. You can think of nodes as a representation of a person in a social network (e.g. Facebook). The ArrayList connectedTo variable in GraphNodes is the list of friends that particular person has. For example, in the following graph, the node O is friends with node 1 and 2. On the other hand, node 2 and node 1 are not friends, hence the lack of link. 0-0 In the constructor of the Graph, the process of connecting nodes is randomized. Moreover, we will not allow a node to be connected to itself and we are going to assume that the arguments passed to the Graph constructor respect the following conditions: n > 2, and n > nbConnections. Pay close attention to the character order