SQL Counting values from joined tables

SQL Counting values from joined tables

References

Reference NO 1

http://stackoverflow.com/questions/15195581/sql-counting-values-from-joined-tables

Reference NO 2

http://stackoverflow.com/questions/7676038/join-tables-count-based-on-value-in-column

Reference NO 3

http://stackoverflow.com/questions/4075018/sql-joining-two-tables-and-counting-items

Reference NO 4

http://stackoverflow.com/questions/11874188/sql-getting-the-count-of-one-table-and-join-the-others

Reference NO 5

http://stackoverflow.com/questions/8239562/sql-server-query-count-on-same-table-twice

Reference NO 6

http://developers.cartodb.com/tutorials/joining_data.html

Reference NO 7

#EANF#

Reference NO 8

#EANF#