Java in-memory database popularity by time

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT 
  d,
  SUM(jooq)     OVER (ORDER BY d) AS jooq,
  SUM(querydsl) OVER (ORDER BY d) AS querydsl
FROM (
  SELECT 
    CAST(CreationDate AS DATE) AS d, 
    COUNT(CASE WHEN Tags LIKE '%<java>%'       THEN 1 END) AS jooq,
    COUNT(CASE WHEN Tags LIKE '%<c#>%'   THEN 1 END) AS querydsl
  FROM Posts
  GROUP BY CAST(CreationDate AS DATE)
) AS DailyPosts
ORDER BY d ASC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results