我如何在这些多个表中使用sql count？

I am still a php/mysql newbie and I am working on mysql table relationship concept and i am having an issue with using mysql count in multiple table. Here is my db structure.I am still a php/mysql newbie and I am working