How can I get a result in SQL that shows summary?

How can I get a result in SQL that shows summary?

References

Reference NO 1

http://stackoverflow.com/questions/7207458/how-to-show-result-sets-that-are-zero-from-the-sum-function

Reference NO 2

http://technet.microsoft.com/en-us/library/ms187810.aspx

Reference NO 3

http://www.oracle.com/technetwork/issue-archive/2013/13-jan/o13sql-1886636.html

Reference NO 4

http://www.w3schools.com/sql/sql_func_sum.asp

Reference NO 5

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473699.htm

Reference NO 6

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=62368

Reference NO 7

http://www.techonthenet.com/sql/sum.php

Reference NO 8

http://www.sfu.ca/sasdoc/sashtml/proc/zsumfunc.htm