0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

SELECT COUNT(Id) as JQwidgetAngular, COUNT(AcceptedAnswerId) as AcceptedAnswers
FROM (
  SELECT Id,Title,Body,CreationDate,AcceptedAnswerId
  FROM Posts 
  WHERE Title LIKE '%[jJ][qQ][wW]%') sub
WHERE 
sub.Title LIKE '%[aA]ngular%' OR
sub.Body LIKE '%[aA]ngular%'
UNION
SELECT COUNT(Id) as KendoAngular, COUNT(AcceptedAnswerId) as AcceptedAnswers
FROM (
  SELECT Id,Title,Body,CreationDate,AcceptedAnswerId
  FROM Posts 
  WHERE Title LIKE '%[Kk]endo%') sub
WHERE 
sub.Title LIKE '%[aA]ngular%' OR
sub.Body LIKE '%[aA]ngular%'

SELECT COUNT(Id) as MaterialAngular, COUNT(AcceptedAnswerId) as AcceptedAnswers
FROM (
  SELECT Id,Title,Body,CreationDate,AcceptedAnswerId
  FROM Posts 
  WHERE Title LIKE '%[Mm]aterial%') sub
WHERE 
sub.Title LIKE '%[aA]ngular%' OR
sub.Body LIKE '%[aA]ngular%'

SELECT COUNT(Id) as OzoneAngular, COUNT(AcceptedAnswerId) as AcceptedAnswers
FROM (
  SELECT Id,Title,Body,CreationDate,AcceptedAnswerId
  FROM Posts 
  WHERE Title LIKE '%[Oo]zone%') sub
WHERE 
sub.Title LIKE '%[aA]ngular%' OR
sub.Body LIKE '%[aA]ngular%'

fork query

edited dec 18 18

created dec 18 18 anonymous