Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT COUNT(a.id), MAX(a.id) FROM ( SELECT TOP 800000 p1.id AS id FROM posts p1 INNER JOIN posts p2 ON p1.acceptedanswerid = p2.id WHERE p1.tags LIKE '%<java>%' and p1.id > 0 order by p1.id ) AS a;