0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

Select 
sub.TagName, MAX(DATEDIFF(hour, sub.CreationDate, ps.CreationDate))
from Posts ps, (Select p.AcceptedAnswerId, p.CreationDate, t.TagName from Posts p, Tags t, PostTags pt where p.Id=pt.PostId AND t.Id=pt.TagId AND t.TagName IN 
('angular', 'angularjs', 'ariatemplates', 'aurelia', 'backbone.js', 'canjs', 'd3.js', 'dekujs', 'dojo', 'durandal', 'ember.js', 'enyo', 'express', 'extjs', 'feathersjs', 'google-closure-library', 'gwt', 'jquery', 'jsblocks', 'kendo-ui', 'keystone', 'knockback.js', 'knockout.js', 'lodash', 'mercury', 'meteor', 'mithril.js', 'mobx', 'modernizr', 'momentjs', 'mootools', 'p5.js', 'polymer', 'preact', 'prototype', 'qooxdoo', 'ractivejs', 'reactjs', 'reagent', 'riot', 'sapui5', 'semantic-ui', 'sizzle', 'socket.io', 'spine', 'sproutcore', 'stapes.js', 'svelte', 'twitter-bootstrap', 'twitter-flight', 'underscore.js', 'vue.js', 'yui', 'zepto')
) as sub where ps.Id=sub.AcceptedAnswerId
GROUP BY sub.TagName
ORDER BY sub.TagName

fork query

edited oct 18 17

created oct 17 17 anonymous