Estimated technology shift compared to the past years

1

Please login or register to vote for this query.

(click on this box to dismiss)

"TechShift" is an estimated percentage of the probability, that you can use a random technology learned in Year1 on the job market of Year2.

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

WITH Raw AS (
  SELECT
    Posts.Id AS PostId,
    MIN(Posts.CreationDate) AS PostCreationDate,
    MAX(Tags.Count) AS MaxTagCount
  FROM Posts, PostTags, Tags
  WHERE
    Posts.Id = PostTags.PostId
    AND
    PostTags.TagId = Tags.Id
  GROUP BY Posts.Id
)
SELECT
  Raw.PostId,
  DATEPART(yyyy, MIN(Raw.PostCreationDate)) AS PostYear,
  MIN(Tags.Id) AS TagId
FROM Raw, PostTags, Tags
WHERE
  Raw.PostId = PostTags.PostId
  AND
  PostTags.TagId = Tags.Id
  AND
  Raw.MaxTagCount = Tags.Count
GROUP BY Raw.PostId

Enter Parameters

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