SQL grouping rows by date and showing counts for each date

SQL grouping rows by date and showing counts for each date

References

Reference NO 1

http://stackoverflow.com/questions/15166213/sql-grouping-rows-by-date-and-showing-counts-for-each-date

Reference NO 2

http://stackoverflow.com/questions/11209507/sql-count-of-open-orders-each-day-between-two-dates

Reference NO 3

http://forums.devshed.com/ms-sql-development-95/how-group-by-date-and-count-rows-in-group-420079.html

Reference NO 4

http://database-programmer.blogspot.com/2008/04/group-by-having-sum-avg-and-count.html

Reference NO 5

http://weblogs.sqlteam.com/jeffs/archive/2007/09/10/group-by-month-sql.aspx

Reference NO 6

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

Reference NO 7

http://p2p.wrox.com/sql-server-2000/49092-sql-query-generate-counts-month.html

Reference NO 8

http://www.bigresource.com/MS_SQL-Count-Records-Between-two-dates-wteSpyq0.html