select
resource.name, hw_name, component_desc, count(resource.name), invprocessor.clock_speed
from
invcomponenttype,invhw,invhwcomponent,invcomponent, resource, invprocessor
where
invcomponenttype.component_type = invhw.component_type AND
invcomponenttype.component_label='Processor' AND
invhwcomponent.HW_ID = invhw.HW_ID AND
invcomponent.component_id = invhwcomponent.component_id AND
invcomponent.Computer_id = resource.resource_id AND
invprocessor.component_id = invcomponent.component_id
GROUP BY
resource.name