/* Which frameworks are the most popular? */

SELECT REGEXP_EXTRACT(url, r'(jquery|dojo|angular|prototype)') type, count(distinct(pageid))
FROM [httparchive:runs.2013_05_15_requests]
WHERE REGEXP_MATCH(url, r'jquery|dojo|angular|prototype')
GROUP BY type;