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
), Raw2 AS (
  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
), Years AS (
  SELECT PostYear, COUNT(*) AS Count
  FROM Raw2
  GROUP BY PostYear
), Raw3 AS (
  SELECT
    Raw2.PostYear,
    Raw2.TagId,
    COUNT(*) AS Count
  FROM Raw2
  GROUP BY Raw2.PostYear, Raw2.TagId
)
SELECT COUNT(*) FROM Raw3

Enter Parameters

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