Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
SELECT c.Id, c.Score, c.Text, c.CreationDate, c.UserId, u.Location, u.Reputation FROM Comments c INNER JOIN Users u ON u.Id = c.UserId WHERE (Location LIKE ##abbr:string## or UPPER(Location) LIKE ##full:string##) AND convert(date, c.CreationDate) >= convert(date, '20200220') AND convert(date, c.CreationDate) <= convert(date, '20200429') AND UPPER(Location) NOT LIKE '%DC%' AND UPPER(Location) NOT LIKE '%D.C.%' AND UPPER(Location) NOT LIKE '%COLUMBIA%'