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 LOWER(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;