I'm trying to query a list of transactions pulled from cdBaby.com which will hopefully result in a top 10 list of tracks sold. As it so happens, this query is returning a ?. I've tried many different variations of this query and the GROUP BY and ORDER BY seem to be the issue (wrong order, or perhaps I cannot ORDER BY a Sum. )
Any direction is very much appreciated.
"SELECT isrc, price_total__cn FROM CD_Baby
WHERE date_of_transaction__cd > ?
isrc IS NOT NULL
Group BY iSRC
ORDER by Sum ( price_total__cn ) desc
" ; ""; "" ; Date ( 1; 1 ; INTERFACE::current_year__cn )