0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT
  SUM(s.cnt_ts) / SUM(s.cnt_js + s.cnt_ts) * 100
FROM (
  SELECT
    COUNT(*) AS cnt_js,
    0.0 AS cnt_ts
  FROM 
    posts p
  WHERE
    p.PostTypeId = 1 AND
    p.Tags LIKE '%<javascript>%'
  UNION
  SELECT
    0.0 AS cnt_js,
    COUNT(*) AS cnt_ts
  FROM 
    posts p
  WHERE
    p.PostTypeId = 1 AND
    p.Tags LIKE '%<typescript>%'
) s

fork query

edited nov 22

created nov 22 Anton.Shchyrov