Shifts Above the Warehouse Average

Problem

Table `Shifts` records, for each picker, how many orders they handled on a given shift: `shift_id`, `picker_id`, and `orders_picked`. Table `Pickers` maps each `picker_id` to a `full_name` and the `warehouse` they belong to.

A warehouse's average load is the average of `orders_picked` across every shift worked by pickers assigned to that warehouse. Find every shift whose `orders_picked` is strictly greater than the average load of the picker's warehouse.

Return `picker_id`, `shift_id`, `full_name` aliased as `picker_name`, and `orders_picked` aliased as `shift_orders`, ordered by `picker_id` then `shift_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns picker_id, shift_id, picker_name, shift_orders.

Starter code (SQL)

SELECT *
FROM Shifts;

Related SQL questions

• 3-Consecutive-Week Marketing StreakHard
• 30-Day Rolling Average Trading VolumeHard
• 7-Day Active User Rolling MetricHard
• 7-Day Revenue Moving AverageHard
• Always Mid-Pack BakersHard
• Annual Energy Output Growth by Panel ModelHard