SELECT R.tid, tname, score, COUNT(score)
FROM(
	SELECT  DISTINCT tid
	FROM result r
	ORDER BY tid) I, Team T, Result r
WHERE I.tid = t.tid AND r.tid=t.tid