Display all values using group by SQL

Display all values using group by SQL

References

Reference NO 1

http://stackoverflow.com/questions/3726682/display-all-values-in-a-group-by

Reference NO 2

http://stackoverflow.com/questions/9871368/counting-null-values-in-sql-with-where-and-group-by-clause

Reference NO 3

http://www.techrepublic.com/article/10-tips-for-sorting-grouping-and-summarizing-sql-data/

Reference NO 4

http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html

Reference NO 5

http://technet.microsoft.com/en-us/library/ms175028(v=sql.90).aspx

Reference NO 6

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

Reference NO 7

http://www.peachpit.com/articles/article.aspx?p=30681&seqNum=8

Reference NO 8

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