SQL Interview Question - Solution (Part - XVI) |

[@MubarakAli-qs9qq]

Very nice

[@kailashpatro5768]

Rider _name : select top 1 r.name, row_number() over(order by fare_amount/distance desc) as rider_per_km from trips12 t inner join riders r on t.rider_id = r.rider_id order by row_number() over(order by fare_amount/distance desc) Driver_name select top 1 d.name, row_number() over(order by fare_amount/distance asc) as driver_per_km from trips12 t inner join drivers d on t.driver_id = d.driver_id order by row_number() over(order by fare_amount/distance asc)

[@krishnasai5806]

Is there any openings for freshers

[@MeanLifeStudies]

As of my knowledge there are very less openings for freshers.

[@MubarakAli-qs9qq]

I love the way u approach the problem😊

[@MeanLifeStudies]

I glad that you liked it. Keep supporting and sharing with your friends and peers. Thank you:)