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.

Was asked at

Practice this question with AI

First session is free - no credit card required.

Go Premium

More interviews, more skills, more success.

Practice More Questions

No answers yet

Be the first to share your approach to this question

Everything You Need to Ace DS Interviews

Frameworks, real cases, and advanced techniques

Proven Frameworks
Structured approaches that work every time
Adequate vs Great Analysis
Learn exactly what makes answers stand out
Real Case Breakdowns
Expert commentary on actual interviews
Advanced Storytelling
Master impactful delivery & presence
See Full Curriculum →

Interview question asked to Data Scientists interviewing at Grubhub, Postmates, Instacart and others: 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..