question

I have the query below, but when I run it, I can only get column names to return. Can someone please help me??? For each subject there are multiple values at each marker. I want an average, by date, for each subject at each marker. I have spent literally hours on this... Thanks in advance for any help!!!! Lori

USE ALS_Smash_BBP
go

select 
    SubjectID
    ,clinicdate
    ,avg(JR_RBHo) AVGJR_RBHo
    ,avg(LL_JRo) AVGLL_JRo
    ,avg(LL_RBHo) AVGLL_RBHo
    ,avg(RC_LCo) AVGRC_LCo
    ,avg(UL_RBHo) AVGUL_RBHo
    ,avg(UL_LLo) AVGUL_LLo
    ,avg(UL_RC_LL_LCo) AVGUL_RC_LL_LCo
from (
    select SubjectID
        ,clinicdate
        ,case Marker when 'JR_RBHo' then MaxSpd else NULL end JR_RBHo
        ,case Marker when 'LL_JRo' then MaxSpd else NULL end LL_JRo
        ,case Marker when 'LL_RBHo' then MaxSpd else NULL end LL_RBHo
        ,case Marker when 'RC_LCo' then MaxSpd else NULL end RC_LCo
        ,case Marker when 'UL_RBHo' then MaxSpd else NULL end UL_RBHo
        ,case Marker when 'UL_LLo' then MaxSpd else NULL end UL_LLo
        ,case Marker when 'UL_RC_LL_LCo' then MaxSpd else NULL end UL_RC_LL_LCo
    from (
        select distinct SubjectID, clinicdate, Marker, MaxSpd
        from dbo.BBP_JerkCost_STATS051810
        where Marker IN ('JR_RBHo','LL_JRo','LL_RBHo','RC_LCo','UL_RBHo','UL_LLo','UL_RC_LL_LCo')
        and MaxSpd is not NULL AND SubjectID = '0069'
    ) x
) xx
group by SubjectID, clinicdate