Trend of questions tagged with [tag] that [do not] contain [search term] in body

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

declare @tagToSearch nvarchar(35) = ##tag:string?google-drive-api##;
declare @textToSearch nvarchar(max) = ##text:string?DriveApp##;

select
  cast(CreationDate as Date) as Created,
  count(Id) as [Questions Posted]
from
  Posts
where
  PostTypeId = 1
  and
  charindex('<' + @tagToSearch + '>', Tags) > 0
  and
  charindex(@textToSearch, Body) > 0
group by
  cast(CreationDate as Date)
order by
  Created

Enter Parameters

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