0

Please login or register to vote for this query.

(click on this box to dismiss)

Вопросы и ответы для программистов

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

view current version

edited nov 22 19

created nov 22 19 Anton.Shchyrov