Migrated questions by time

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

SELECT
  CONVERT(DATE, CreationDate),
  COUNT(Id)
FROM Posts P
WHERE PostTypeId = 1
AND P.Id in (SELECT PostId
FROM PostHistory H
WHERE H.PostHistoryTypeId = 35
AND H.Comment LIKE 'to http://%')

GROUP BY CONVERT(DATE, CreationDate)
ORDER BY CONVERT(DATE, CreationDate)

Enter Parameters

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