WITH prolific_user_cte AS( SELECT u.Id 'users_u', ROUND(...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

WITH prolific_user_cte AS( 

SELECT u.Id 'users_u', ROUND(AVG(CAST(p.Score AS FLOAT)), 2) 'avg_score'
		FROM
			Users u
	INNER JOIN Posts p ON p.OwnerUserId = u.Id
    GROUP BY u.Id
--    HAVING avg_score > 1.5
)
select * from prolific_user_cte

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results