0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT *
FROM tags



SELECT SUM(P.score), T.tagname
FROM tags T, posts P
WHERE P.tags LIKE '%'+T.tagname+'%'
GROUP BY tagname


SELECT Count
FROM tags
WHERE tagname='full-house'

SELECT P.score, T.tagname
FROM tags T, posts P
WHERE P.tags LIKE '%'+T.tagname+'%'

SELECT P.score, T.tagname, T.count
FROM (SELECT * FROM Tags WHERE count>4) T, posts P
WHERE P.tags LIKE '%'+T.tagname+'%'
ORDER BY T.count


SELECT AVG(P.score) AS AvgScore, T.tagname
FROM (SELECT * FROM Tags WHERE count>4) T, posts P
WHERE P.tags LIKE '%'+T.tagname+'%'
GROUP BY tagname
ORDER BY AvgScore DESC

fork query

edited mar 5 19

created mar 5 19 anonymous