Tag statistics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском

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

SELECT
  SUM(s.cnt_ts) / SUM(s.cnt_js) * 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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results