Practice Amazon SQL Question | Real Coding Interviews

Quick Summary

Calculate batch composition and size by grouping items by type.
Prioritize warehouse capacity allocation for prime batches before distributing remaining space to non-prime batches.
Use floor operations to ensure only whole batches are counted toward the final inventory.

What This Tests

Aggregation and grouping to derive batch metrics
Conditional resource allocation logic
Integer truncation for discrete unit constraints
Result set combination and deterministic ordering

Common Patterns

Aggregation

Groupby

Union

Sort

Table: inventory

+----------------+---------+
| Column Name    | Type    |
+----------------+---------+
| item_id        | integer |
| item_type      | string  |
| item_category  | string  |
| square_footage | decimal |
+----------------+---------+
item_id is the primary key. item_type is either 'prime_eligible' or 'not_prime'. square_footage is the space one unit requires.

Test Cases

Input

Output

Expected