Never Too Old To Learn

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT
    U.Id AS [User Link],
    P.Id As [Post Link]


FROM Posts P
    INNER JOIN Users U on U.Id = P.OwnerUserId
    WHERE 
        P.PostTypeId = 1 AND
        P.CreationDate >= '2016-01-01' AND P.CreationDate <= '2016-12-31' AND
        U.CreationDate <= '2014-01-01'
    GROUP BY
        U.Id, P.id
    ORDER BY
        U.Id DESC

Enter Parameters

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