SQL

Here is table A with these variables like delivery ages and their location and orders, here is table B with orders, destination and their prices. Find the average delivery distance per agent. Sort in descending order of total orders delivered.

Data Scientist

DoorDash

Glovo

Did you come across this question in an interview?

Your answer

  • Here is table A with these variables like delivery ages and their location and orders, here is table B with orders, destination and their prices. Find the average delivery distance per agent. Sort in descending order of total orders delivered.
  • Take a look at the provided tables. Calculate the average delivery distance per agent and then sort them by total orders delivered in descending order.
  • Can you analyze the given tables and determine the average delivery distance per agent? Also, sort the agents according to their total orders delivered in descending order.
  • Analyze the tables. Sort the agents by total orders delivered in descending order and then calculate the average delivery distance per agent.
  • Using the given tables, find the average delivery distance per agent, and then sort the agents by the total orders delivered in descending order.
  • Sort the agents by total orders delivered in descending order, and then calculate the average delivery distance per agent using the provided tables.
  • Analyze the tables and find the average delivery distance per agent. Sort the agents by total orders delivered in descending order.
  • Using the provided tables, find the average delivery distance per agent and then sort them in descending order of total orders delivered.
  • Determine the average delivery distance per agent using the provided tables, and then sort the agents by their total orders delivered in descending order.
  • Practice analyzing tables to determine the average delivery distance per agent, and then sort the agents by the total orders delivered in descending order.
  • Please analyze table A and B. Sort the delivery agents in descending order of total orders delivered and find out the average delivery distance per agent.
Try Our AI Interviewer

Prepare for success with realistic, role-specific interview simulations.

Try AI Interview Now

Interview question asked to Data Scientists interviewing at Glovo and DoorDash: Here is table A with these variables like delivery ages and their location and orders, here is table B with orders, destination and their prices. Find the average delivery distance per agent. Sort in descending order of total orders delivered..