Exercise 1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT t.Id, TagName, SUM(p.score) / COUNT(p.Id) as AvgScore
FROM tags as t
JOIN posts as p
ON t.Id = p.Id
WHERE t.Count > 4
GROUP BY t.Id, TagName
ORDER BY AvgScore DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results