Count of Models by Collection

select
    Model0,
    Count(*)
from
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_FullCollectionMembership FCM
Where
    CS.ResourceId = FCM.ResourceId
    And CollectionID = ‘SMS00001’
Group by
    Model0