Company SQL Question

Warehouse Performance Analysis

Practice this Amazon style SQL interview question with live execution and instant feedback.

Problem Statement

For each warehouse, calculate the total number of shipments, total employees, and capacity utilization percentage. Show warehouse name, location, employee count, shipment count, and capacity.

Relevant Tables

warehousesemployeesshipments

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

INNER JOIN Deep DiveJoins & Relationships
Window Functions FundamentalsWindow Functions
COUNT, SUM, AVG, MIN, MAXAggregate Functions & Grouping