SELECT entry AS ' ', SUM(Entryid) AS ' ' FROM foobarVille GROUP BY entry

CREATE TABLE #T(tmessage VARCHAR(200))
INSERT INTO #T
SELECT 'Short' UNION ALL
SELECT 'Longer' UNION ALL
SELECT 'Even a longer message' UNION ALL
SELECT 'A realy realy realy extra long message'

select SUM(200 -Len(tmessage)) AS WASTED,AVG(200 -Len(tmessage)) AS 'Average Wasted'
FROM #T

DROP TABLE #T

CREATE TABLE #T(tmessage VARCHAR(200))
INSERT INTO #T
SELECT 'Short' UNION ALL
SELECT 'Longer' UNION ALL
SELECT 'Even a longer message' UNION ALL
SELECT 'A realy realy realy extra long message truly really long'

select SUM(200 -Len(tmessage)) AS WASTED,AVG(200 -Len(tmessage)) AS 'Average Wasted',
MIN(200 -Len(tmessage)) AS 'Minimum Wasted'
FROM #T

DROP TABLE #T