0

Please login or register to vote for this query.

(click on this box to dismiss)

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

WITH predvyber AS (
  SELECT
    COUNT(PostTypeId) AS pocet,
    Users.Id,
    Users.DisplayName
  FROM
    Posts
  JOIN
    Users ON Posts.OwnerUserId = Users.Id
  GROUP BY
    Users.Id,
    Users.DisplayName
) 
SELECT
  count(predvyber.Id) AS vysledek
FROM
  predvyber
WHERE
  predvyber.pocet > 10;

view current version

edited mar 2

created mar 2 jon.doe43923