Q&A for scientific skepticism
SELECT p.Id AS PostId, p.PostTypeId, p.CreationDate AS PostDate, p.Score, 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 '%DC%' AND UPPER(Location) NOT LIKE '%D.C.%' AND UPPER(Location) NOT LIKE '%COLUMBIA%'