Question
The retail operations manager can review one store first. Among stores with at least three order headers in the second quarter of 2025, which has the highest observed fraction marked returned? Break a tied fraction by the smaller STORE_ID.
Evidence
Use SALES.ORDERS and SALES.STORES. Count all Q2 store order headers in the denominator, including cancelled orders, because that is the manager's stated definition. The answer prioritizes a review; it doesn't establish why returns happened.
A high count of returned orders can reflect a busy store rather than a high return fraction. The manager's question therefore supplies a denominator: all second-quarter store order headers. It also supplies a minimum of three order headers before comparing stores. Use that definition consistently instead of changing it when a result looks inconvenient.
Inspect the eligible orders, build counts, and calculate the fraction before attaching store names. The final query returns one store to review, using the unrounded fraction for sorting and STORE_ID to break a tie. Rounded display values can hide a difference, so don't rank on the displayed rate alone. The result identifies an investigation priority, not a causal explanation.