E-commerce & Retail Analytics Path · Mission 12 of 30Medium

Refund rate by product

Compute a per-product refund rate using conditional aggregation. Three-way join (product → line-item → order) and a ratio with the float-math float-divide-zero guard.

The Brief

You'll practice

Conditional aggregationRatioSelf-join