instruction: Which questions have no popular tags?. The proliferation of tags can mean that many questions have no popular tags. Such questions are more difficult to find, and do not contribute to enabling the 'Generalist' badge for smaller sites.
  
  Here, choose a threshold (i.e., 40, for top 40 tags), and this query will return all questions that have no tags that popular. It will also provide the name of the question's most popular tag.
  
  Related: Query 342344 (Which open or duplicate questions have no popular tags?)
response: WITH My_Table AS (SELECT t.Id AS Tag_ID, t.TagName AS Tag_Name, t.Count AS Count, p.Id AS Post_ID, p.Title AS Post_Title, p.PostTypeId AS Type, p.OwnerUserId AS Owner, MAX(t.Count) OVER (PARTITION BY p.Id) AS Max_Count FROM Tags AS t INNER JOIN PostTags AS pt ON t.Id = pt.TagId INNER JOIN Posts AS p ON pt.PostId = p.Id) SELECT Tag_ID, Tag_Name, 'site://questions/' + CAST(Post_ID AS TEXT) + '|' + Post_Title AS Post, Max_Count FROM My_Table WHERE Type = 1 AND Max_Count = Count AND Max_Count < @Threshold ORDER BY Max_Count