Get posts of users in a state (detailed)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing

Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing

SELECT p.Id AS PostId, p.PostTypeId, p.CreationDate AS PostDate, p.Score, p.ViewCount, p.AnswerCount, p.CommentCount, p.OwnerUserId, u.Location, u.Reputation
FROM Posts p
INNER JOIN Users u ON u.Id = p.OwnerUserId
WHERE 
    (Location LIKE ##abbr:string## 
    or UPPER(Location) LIKE ##full:string##) 
    AND convert(date, p.CreationDate) >= convert(date, '20200220')
    AND convert(date, p.CreationDate) <= convert(date, '20200429')
    AND UPPER(Location) NOT LIKE '%, WA%'
    AND UPPER(Location) NOT LIKE '%WEST VIRGINIA%'

Enter Parameters

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