ภาษา TIO ตามความนิยม [ขาด] ไม่จำเป็นต้องใช้ตารางทั้งหมด
TIO Languages by Popularity [BROKEN].It is not neccessary to use all the tables.
 Users:  Id [ number]  Reputation [ number]  CreationDate [ time]  DisplayName [ text]  LastAccessDate [ time]  WebsiteUrl [ text]  Location [ text]  AboutMe [ text]  Views [ number]  UpVotes [ number]  DownVotes [ number]  ProfileImageUrl [ text]  EmailHash [ text]  AccountId [ number] 
SELECT SUBSTRING(Body, PATINDEX('%http://*.tryitonline.net', Body) + 7, STR_POSITION(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, STR_POSITION(Body, '.', PATINDEX('%http://*.tryitonline.net', Body)) - PATINDEX('%http://*.tryitonline.net', Body) + 6)