SELECT Count(tblOrder.orderId) AS CountOforderId, First(tblCd.cdTitle) AS FirstOfcdTitle, First(tblCd.cdArtist) AS FirstOfcdArtist
FROM tblCd INNER JOIN tblOrder ON tblCd.cdId=tblOrder.cdId
GROUP BY tblCd.cdId;