Top 10 senders by total number of parcels shipped
SQL query for SendCloud
Identify the top 10 senders by the total number of parcels shipped from the sender_addresses table.
SELECT sa.name AS sender_name, COUNT(*) AS total_shipped_parcels FROM sender_addresses sa JOIN parcels p ON sa.id = p.sender_address_id GROUP BY sa.name ORDER BY total_shipped_parcels DESC LIMIT 10
SendCloud data model
Parcels
Parcel Labels
Integrations
Integration Shipments
Pickups
Returns
Invoices
Shipping Methods
Sender Addresses
Brands
Contracts
Shipping Functionalities
Orders
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed