Problem Β· Database

Customer Package Delivery Report

● EasyAmazonOA
See Amazon hiring insights

Problem statement

As part of Amazon's logistics control panel, the shipping team needs a report that returns a list of all customer packages that are currently in the process of being delivered.

The problem statement continues
Pro

Examples

Example 1

placeholder = "SQL_REFERENCE_ONLY"return = "READ_ONLY"

This is a format placeholder only. It is not a source SQL example and does not execute a database query.

Original screenshot from the interview report
Pro
FastPrep Pro
Reported in 1 Amazon interview this week

Unlock the full problem

  • Full problem statement and constraints
  • Worked examples, explained
  • Guided hints and editorial
  • Run your code on real test cases
$9/month

Pro subscription, billed yearly β€” or $19 month-to-month. Cancel anytime.

Free plan β€” 2 of 2 free unlocks used this week
CodePython 3
Run and Submit unlock with Pro
FastPrep Pro
Reported in 1 Amazon interview this week

Unlock the full problem

  • Full problem statement and constraints
  • Worked examples, explained
  • Guided hints and editorial
  • Run your code on real test cases
$9/month

Pro subscription, billed yearly β€” or $19 month-to-month. Cancel anytime.

Free plan β€” 2 of 2 free unlocks used this week