"Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct"

"An item with the same key has already been added"

Select *
from
(Select distinct srt.Name,
    percentile_disc(.5) WITHIN GROUP(ORDER BY (sr.price)) OVER(PARTITION BY srt.Name) AS    MedianSpend
    from ServiceReq sr inner join ServiceReqTemplate srt
    on srt.RecId = sr.SvcReqTmplLink_RecID Where Name like '%') medQuery
    inner join

(select distinct srt.Name,
    cast(sum(sr.price) as int) as AvgCost,cast(sum(sr.cost) as int) as
    AvgTransCost,cast(avg(sr.TotalTimeSpent) as int) as TotalTimeSpent
    from ServiceReq sr, ServiceReqTemplate srt
    where sr.SvcReqTmplLink_RecID = srt.RecId
    group by srt.Name) avgQuery
    on medQuery.Name LIKE avgQuery.Name