What are the top ten worst rides with respect to time and distance? In other words, who
Question:
What are the top ten worst rides with respect to time and distance? In other words, who sat in the taxi the longest and went the shortest distance? You should remove any ride whose trip_distance is 0. We want to maximize the following calculation:
(number of seconds in the taxi / trip_distance)
To ensure you are picking the correct row, your answer should include all information about the row (i.e. the entire row). Your answers must include a new column representing the above calculation. You only need to display 10 answers and do not need to worry about ranks.
Table A Schema:
VendorID: Number
tpep_pickup_datetime: Date & Time
tpep_dropoff_datetime: Date & Time
passenger_count: Number
trip_distance: Number
RatecodeID: Number
store_and_fwd_flag: Plain Text
PULocationID: Number
DOLocationID: Number
payment_type: Number
fare_amount: Number
extra: Number
mta_tax: Number
tip_amount: Number
tolls_amount: Number
improvement_surcharge: Number
total_amount: Number
Financial Accounting and Reporting a Global Perspective
ISBN: 978-1408076866
4th edition
Authors: Michel Lebas, Herve Stolowy, Yuan Ding