WITH c AS ( SELECT OwnerUserId, Body, 1 AS t FROM Posts W...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

-- Enter Query Title
-- Enter Query Description
WITH c AS
(
    SELECT OwnerUserId, Body, 1 AS t
        FROM Posts
        WHERE CreationDate >= 'August 13, 2010'  -- http://meta.stackoverflow.com/q/60782
)
SELECT
    OwnerUserId AS [User Link],
    SUM(t) AS Count
    FROM c
    WHERE Body LIKE 'amazon'
    GROUP BY OwnerUserId WITH ROLLUP
    ORDER BY SUM(t) DESC

Enter Parameters

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