0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and amateur woodworkers

WITH TagMaps AS (SELECT * FROM (VALUES
('sh','bash'), ('sh','bsh'), ('sh', 'csh'), ('sh', 'sh'),
('c', 'c'), ('c', 'cyc'), ('c', 'm'), ('clojure', 'clojure'), 
('coffee', 'coffeescript'),
('c++','c++'), ('c#','c#'), ('css','css'), ('dart','dart'),
('pascal', 'delphi'), ('pascal', 'pascal'), ('erlang', 'erlang'), ('go',
'go'), ('haskell', 'haskell'), ('http', 'http'),
('ini', 'ini'), ('ini', 'toml') )AS foo(highlight, tag))

SELECT Highlight, SUM([Count]) FROM Tags
JOIN TagMaps ON tag = TagName
GROUP BY highlight
ORDER By SUM([Count])  ASC

fork query

edited dec 3

created dec 3 anonymous