GROUP BYSUM
Return symbol, the number of trades (as trades) and total traded value rounded to 2 (as notional, shares * price) per symbol. Sort by notional descending, then symbol.
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.