Technical

An inventory table has records for each product's warehouse location and quantity on hand. Write a query to identify which warehouses have less than a 1 month supply of any given product.

Business Intelligence Engineer

Amazon

Did you come across this question in an interview?

Your answer

Try Free AI Interview

Google logo

Google

Product Manager

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

Product Strategy
Meta logo

Meta

Product Manager

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

Product Sense
Meta logo

Meta

Engineering Manager

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

System Design
Amazon logo

Amazon

Data Scientist

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

Behavioral
  • An inventory table has records for each product's warehouse location and quantity on hand. Write a query to identify which warehouses have less than a 1 month supply of any given product.
  • How would you use SQL to find warehouses with under a one-month supply of any product?
  • Given inventory levels and product locations, write a query to flag warehouses low on stock (less than a month's worth).
  • Suppose you have inventory quantities by warehouse — how do you identify which ones are understocked?
  • Write a SQL query to find all warehouse-product pairs with less than 1 month of inventory on hand.
  • How would you spot low-supply items in each warehouse using an inventory dataset?
  • From an inventory table, how do you figure out which warehouses are short on supply for any product?
  • Can you write a query to detect which warehouse locations are running low on any product?
  • How would you find products that are understocked in specific warehouses using SQL?
  • Write a query to identify warehouses with insufficient inventory to cover one month's expected demand.
  • Using an inventory table, how do you flag products that are below a one-month threshold in their warehouse?

Interview question asked to Business Intelligence Engineers interviewing at Amazon: An inventory table has records for each product's warehouse location and quantity on hand. Write a query to identify which warehouses have less than a 1 month supply of any given product..