# SQL interview question: identify the least efficient driver

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/2220/sql-query-least-efficient-driver
Source observed: 2026-11-05T00:06:34.015Z
Last checked: 2026-11-05T00:06:34.015+00:00
Indexed: 2026-11-07T03:14:44.808+00:00

---

# Write a SQL query to identify the least efficient driver in terms of deliveries per time spent driving in the last two months using the given dataset.

We publish this as an Aced (formerly Exponent) interview-practice question. It is a **technical** question associated with **BizOps & Strategy** roles and **Instacart**.

- **Interview:** 1 interview
- **Last asked:** 4 years ago
- **Category:** [Technical](https://www.aced.io/questions?type=technical)
- **Role:** [BizOps & Strategy](https://www.aced.io/questions?role=bizops)
- **Company:** [Instacart](https://www.aced.io/questions?company=instacart)

## What you need to solve

Write a SQL query that uses the given dataset to identify the driver with the lowest efficiency, where efficiency is measured as deliveries completed per amount of time spent driving during the last two months.

The accessible content does not include the dataset schema, column names, sample rows, expected SQL dialect, or a worked solution. We therefore provide the interview prompt without adding a query or unsupported implementation details.

## Access and answering

Detailed company statistics for this question require [Upgrade](https://www.aced.io/upgrade?src=questions). To submit an answer, [log in or sign up](https://www.aced.io/signup?src=nav&returnPath=/questions/2220/sql-query-least-efficient-driver); submitting marks the question complete.

## Community answers

No answers have been contributed by the community yet.

## Related question

- [Write a SQL query to sum the number of rides and deliveries completed for each zip code using the given dataset.](https://www.aced.io/questions/2219/sql-query-sum-rides-deliveries-zipcode)

## Related courses

### [Product Strategy Questions](https://www.aced.io/courses/product-strategy)

![Product Strategy Questions](https://images.ctfassets.net/x78yjrjc11pq/5hHtTyOypgyKA7R3fxMlyl/dde193ecc09baabd8304c3aec25483f2/product_strategy_course_ab4d3cf294.jpeg?w=800&h=800&fm=webp&q=75)

We teach approaches for product-strategy interviews in the AI era, including how to approach these rounds under the new rules.

### [BizOps & Strategy Interview Prep](https://www.aced.io/courses/bizops)

![BizOps & Strategy Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/4UiKk2RC0mwffqXcDuADSE/aa4e742618ba2e364b78a9e2a5276c6d/bizops_track_compressed_a18a42bcca__281_29_66d3d45075.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for operations and strategy roles at Google, Meta, Amazon, Uber, Microsoft, and other top companies through mock interviews, frameworks, and advice from senior candidates. The course covers strategic decision-making, stakeholder management, product strategy, analytics, and behavioral interviews.

## Browse Aced

- [All questions](https://www.aced.io/questions)
- [SQL questions](https://www.aced.io/questions?type=sql&filterBy=codeEditor&src=nav)
- [Courses](https://www.aced.io/courses?src=nav)
- [Practice](https://www.aced.io/practice?src=nav)
- [Coaching](https://www.aced.io/coaching?src=nav)
- [Pricing](https://www.aced.io/upgrade?src=nav)

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F2220%2Fsql-query-least-efficient-driver&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F2220%2Fsql-query-least-efficient-driver). Opening a form does not execute a tool.