instruction: Tag Wikis that are Too Short.
response: SELECT Tags.TagName AS "name", Tags.Count AS "number_of_posts", Tags.Id AS "tag_id", LENGTH(ex.Body) AS "tag_summary_length", LENGTH(ex.Body) - LENGTH(REPLACE(ex.Body, ' ', '')) AS "words_in_tag_summary", LENGTH(w.Body) AS "tag_wiki_length", LENGTH(w.Body) - LENGTH(REPLACE(w.Body, ' ', '')) AS "words_in_tag_wiki" FROM Tags LEFT JOIN Posts AS ex ON Tags.ExcerptPostId = ex.Id AND ex.PostTypeId = 4 LEFT JOIN Posts AS w ON Tags.WikiPostId = w.Id AND w.PostTypeId = 5 WHERE LENGTH(ex.Body) < 50 OR LENGTH(w.Body) < 100 OR NOT w.Body LIKE '%*_\!=()[-#_+`%' ORDER BY Tags.Count DESC