DAI Practice Query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Tridion

Q&A for Tridion developers and administrators

WITH top_ten_users AS(
  SELECT TOP 10 OwnerUserId, SUM(SCORE) AS totalScore
  FROM posts 
  WHERE (Tags LIKE '%sql%'
  OR Tags LIKE'%python%'
  OR Tags LIKE '%<R>%')
  AND OwnerUserId IS NOT NULL
  GROUP BY OwnerUserId
  ORDER BY totalScore DESC)
  
SELECT displayName, 
CONCAT ('https://stackoverflow.com/users/', id) AS profileUrl,
totalScore
 FROM top_ten_users AS t
  INNER JOIN users AS u
   ON t.ownerUserId = u.id;

Enter Parameters

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