0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

WITH TABLE1 AS (
SELECT 
 Id,
 SUM(CommentCount) sum_comment,
 SUM(FavoriteCount) sum_fav
FROM Posts
GROUP BY Id )
SELECT
 Id
FROM TABLE1
WHERE sum_comment > sum_fav

fork query

created nov 14 anonymous