How does one "SUM" and "GROUP BY"?
I'm afraid, there's no way to
SELECT DISTINCT. SMW selects pages (and internal objects). You can only use nested queries: first select dates (and you have to use Array extension or Lua to make selection distinct), format the selection with a template and include a query for
Total into the template. Or use Lua from the beginning.