Please help me to clear my first coding interview...I'm stuck... I am asked to create an API which will display a list of riders and total distance required for them to deliver the order. The list should be sorted based on shortest delivery distance to the highest with respect to the restaurant’s and rider’s location.
It has to be done using node.js and MySQL only...please help.....Ive attached the link to the provided MySQL file.
Each restaurant will have a delivery radius outside which the orders must not be accepted or delivered.
The riders within the restaurant’s delivery radius should only be considered for the response.
API Request: Restaurant ID & User coordinates.
API Response: List of Rider Names and total distance to deliver order to user