Total Parcel Weight per Courier

Problem

A delivery depot tracks every parcel its couriers carry. Management wants the total weight each courier has delivered, including couriers who have not delivered anything yet.

Table: `couriers`

| Column | Type |
|-------------|---------|
| courier_id | int |
| courier_name| varchar |

`courier_id` is the primary key.

Table: `deliveries`

| Column | Type |
|-------------|---------|
| delivery_id | int |
| courier_id | int |
| weight_kg | int |

`delivery_id` is the primary key. `weight_kg` is the weight of one delivered parcel by the courier.

Write a query that reports, for every courier, the total weight they delivered as `total_weight`. A courier with no deliveries should report `0`. Order the result by `total_weight` descending; when two or more couriers have the same total, order those by `courier_name` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 7 rows with the columns courier_name, total_weight.

Starter code (SQL)

SELECT *
FROM couriers;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy