0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT Tags, AVG(Score) OVER(PARTITION BY Tags) as average_score 
FROM Posts, (SELECT TOP 2 TagName FROM Tags WHERE Count >= 5) as t
WHERE Tags LIKE CONCAT('%', t.TagName,'%')

fork query

edited feb 28 19

created feb 28 19 anonymous