select sae_subcategorymaster.subject,count(sae_tblbookdetail.title) from sae_tblbookdetail inner join sae_subcategorymaster on sae_subcategorymaster.subject=sae_tblbookdetail.subject group by sae_subcategorymaster.subject