WHEREGROUP BY
Open opportunities are those whose stage is not 'closed won' or 'closed lost'. Return region and the total open amount (as open_pipeline) per rep region, largest first.
Guest mode · solve history stays on this device; code isn’t saved. Sign in to save future work
query.sql
loading editor…
Run your code to see its output, or check your solution to grade it.