0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT
  PostHistoryTypes.Id,
  MIN(PostHistoryTypes.Name) AS Name,
  COUNT(CASE WHEN SUBSTRING(Text, 1, 2) = '{"' THEN 1 END) AS JsonCount,
  COUNT(*) AS AllCount
FROM PostHistory, PostHistoryTypes
WHERE
  PostHistory.Id % 100 = 0
  AND
  PostHistory.PostHistoryTypeId = PostHistoryTypes.Id
GROUP BY PostHistoryTypes.Id
ORDER BY Id

view current version

edited jan 21

created jan 21 peterh - PLEASE DELETE THIS ACCOUNT