00:00

1511. Avg Shipping Fee by Service Level (Delivered)

MediumSQLITE44 / 1584

Relevant companies

Amazon

Walmart

Target

Instacart

Shopify

eBay

Etsy

Wayfair

Chewy

Kroger

Costco

Best Buy

Home Depot

IKEA

Alibaba

Flipkart

Mercado Libre

Rakuten

Faire

Coupang

1511. Avg Shipping Fee by Service Level (Delivered)

Medium44 / 1584

Relevant companies

Amazon

Walmart

Target

Instacart

Shopify

eBay

Etsy

Wayfair

Chewy

Kroger

Costco

Best Buy

Home Depot

IKEA

Alibaba

Flipkart

Mercado Libre

Rakuten

Faire

Coupang

Sign in to Practice

Write SQL and Python, run instantly in your browser, and track your progress.

Runs live in your browser — no setup
Save progress across all 1,500+ problems
Submit and validate your answer instantly

Business Problem

Logistics wants to compare shipping fee averages across service tiers for successfully delivered shipments. Provide the average fee per service level. Sort from the highest average to the lowest; break ties by the service level name.

Schema: shipments

Column Name	Type
shipment_id	INTEGER
order_id	INTEGER
warehouse_code	TEXT
carrier_name	TEXT

Business Problem

Schema: shipments

Column Name	Type
shipment_id	INTEGER
order_id	INTEGER
warehouse_code	TEXT
carrier_name	TEXT

Avg Shipping Fee by Service Level (Delivered) — SQL Medium | Let's Data Science | Let's Data Science

service_level	avg_shipping_fee
overnight	29.99
two_day	19.99
expedited	14.99
standard	7.994
economy	5.093

service_level	avg_shipping_fee
overnight	29.99
two_day	19.99
expedited	14.99
standard	7.994
economy	5.093

1511. Avg Shipping Fee by Service Level (Delivered)

Relevant companies

Tags

1511. Avg Shipping Fee by Service Level (Delivered)

Relevant companies

Tags

Sign in to Practice