Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

SQL for On-Time Shipment Rates

Medium
MediumSQL & Data ManipulationJoinsGroup ByAggregationsAsked 1 times

Problem

Write a SQL query to identify the top 10 warehouses by on-time shipment rate over the last 90 days, including total shipments, on-time shipments, and on-time percentage.

Practicing as: Operations Manager interview at 48forty Solutions

Hi, I'll play your 48forty Solutions interviewer for the Operations Manager role. Candidates describe these interviews as mostly positive and on the easier side, so expect me to be friendly and conversational. Take your time with the question above and answer like we're in the room.

Take this as a live interview session →

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
48forty Solutions Operations Manager Interview Questions48forty Solutions Interview Questions
Next questions
VerkadaSQL for Weekly Shipment PerformanceMediumNestlé USASQL: Top SKUs for Late ShipmentsMediumJ&B Medical SupplySQL for Shipment PerformanceMedium