TIO Languages by Popularity [BROKEN]

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT SUBSTRING(Body, PATINDEX('%http://*.tryitonline.net', Body) + 7, CHARINDEX('.', Body, PATINDEX('%http://*.tryitonline.net', Body)) - PATINDEX('%http://*.tryitonline.net', Body) + 6) AS Language, COUNT(*) AS Frequency FROM Posts
WHERE PostTypeId = 2
GROUP BY SUBSTRING(Body, PATINDEX('%http://*.tryitonline.net', Body) + 7, CHARINDEX('.', Body, PATINDEX('%http://*.tryitonline.net', Body)) - PATINDEX('%http://*.tryitonline.net', Body) + 6);

Enter Parameters

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