0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

SELECT
  P.Id,
  P.ParentId,
  P.CreationDate,
  P.ViewCount,
  P.Title,
  P.Body,
  P.Tags
FROM
  Posts as P
WHERE
  P.tags LIKE '%<java>%'
  AND P.CreationDate BETWEEN '2018-12-01' AND '2020-09-30'
  AND P.ParentId IS NOT NULL
ORDER BY
  P.ViewCount DESC;

fork query

edited oct 29 user25376965

created may 8 20 anonymous