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

Programming Writing Montreal Maps In the following questions, you will write classes that allow one to suggest a route to get from one point to another on a metro or train line. Note that for all of these questions, we will make the simplifying assumption that the earth is flat and that everything resides in 2 dimensions. (There were metros before Columbus and Galileo, right?) 6. Write a class MetroStation in which you define a new type MetroStation. (10 points) A MetroStation is defined to have the following private properties: • String name This represents the name of the metro station (e.g. Atwater, McGill, etc) • double xPosition This represents the x location of the metro station. • double y Position This represents the y location of the metro station. An MetroStation object should have the following public methods/behaviors defined on it. • A constructor that takes as input a String stationName, a double x, and a double y. The constructor should initialize the properties name, xPosition, and yPosition to these three values respectively • A method getName() which returns the name of the Metrostation. • A method get XPosition () which returns the x location of the Metrostation • A method get Position () which returns the y location of the Metrostation • A method equals (Metrostation other) which returns a boolean representing whether the name property of the this MetroStation is equal to the name property of other.