Journey to be a Generalist


Please login or register to vote for this query.

(click on this box to dismiss)

Based on Q#734, the accepted answer in meta

Artificial Intelligence Meta

Q&A about the site for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

-- Journey to be a Generalist
-- Based on Q#734, the accepted answer in meta

with top40 as (
  select top 40, t.tagname
  from tags t, posttags pt
  where pt.tagid =
  group by t.tagname,
  order by count(pt.postid) desc

myanswers as(
  select p.parentid, p.score
  from posts p
    p.owneruserid = ##UserID## and
    p.communityowneddate is null

select t40.tagname as 'Tag', sum(p1.score) as 'Score',
case when sum(p1.score) >= 15 then ':-)' else ':-(' end as 'Status'
from top40 t40, myanswers p1, posttags pt1
  pt1.postid = p1.parentid and
  pt1.tagid =
group by t40.tagname
order by sum(p1.score) desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results