select * from hymns where composer matches "C*" order by composer,tunename

Weary Pilgrim's Consolation29812, 11, 12, 11, 12, 12, 12, 11How sweet to reflect on the joys that await meC. H. Pare
Funeral Thought25713, 12, 11Thou are gone to the grave--but we will not deplore theeCaldwell
Immensity319L.M.There is a world we have not seenCaldwell
Messiah97C.M.He comes! he comes! to judge the worldCarreil
The Mouldering Vine878, 7Hail! ye sighing sons of sorrowCarrell
Ninety-Third Psalm7S.M.Grace! 'tis a charming soundChapin
Olney648, 7Come, thou fount of ev'ry blessingChapin
Primrose3C.M.Salvation! O the joyful sound!Chapin
Rockbridge288L.M.Life is the time to serve the LordChapin
Rockingham [2]300bC.M.Come, happy souls, approach your GodChapin
Tribulation119C.M.Death, 'tis a melancholy dayChapin
Vernon34L.M.Come, O thou traveller unknownChapin
Aylesbury281S.M.And am I born to die?Chetham
Interrogation2497sHark! my soul, it is the LordChristopher
Wondrous Love25212, 9, 6, 6, 12, 9What wondrous love is this, oh! my soul!Christopher
Olive Shade3308, 6, 8, 4Father, who in the olive shadeCol. Daniel Smith
Ninety-Fifth27bC.M.When I can read my title clearColton