使用外键引用行的计数进行多表选择

I've tables related with foreign keys and i try to prepare a view to compose them via inner joins on SQL Server. I don't know if using inner join's is the way, but I can't get what I want anyway.I've tables related with foreign keys and i try