Regarding 4. did you check the WITH ROLLUP clause? I think that what's really lacking here are the "window" functions like the ones in the works for PostgreSQL (see http://www.gavinsherry.org/talks/window_talk.pdf)
More information about formatting options
Regarding 4. did you check
Regarding 4. did you check the WITH ROLLUP clause? I think that what's really lacking here are the "window" functions like the ones in the works for PostgreSQL (see http://www.gavinsherry.org/talks/window_talk.pdf)