Chapter 4 Exercise 27

27. List the component product number and weight that are in the SRAM Red 2012 groupo.

SELECT Groupo.GroupName, Component.ComponentID, Component.ManufacturerID, Component.ProductNumber, Component.Weight
FROM Groupo INNER JOIN (Component INNER JOIN GroupComponents
ON Component.ComponentID = GroupComponents.ComponentID) ON Groupo.ComponentGroupID = GroupComponents.GroupID
WHERE (((Groupo.GroupName)="SRAM Red 2012"));