SELECT CAST(TextData as varchar(100)),
COUNT(CAST(TextData as varchar(100))) AS NumOccurrences, SUM(READS) as Reads, SUM(READS) * COUNT(CAST(TextData as varchar(100))) as OverallReadCost, SUM(CPU) * COUNT(CAST(TextData as varchar(100))) as OverallCPUCost
FROM LiveMay5
GROUP BY CAST(TextData as varchar(100))
HAVING ( COUNT(CAST(TextData as varchar(100))) > 10 )
ORDER BY NumOccurrences DESC