0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT
COUNT(*) AS Num_Posts,
SUM(CASE WHEN C.PostId IS NULL THEN 1 ELSE 0 END) AS Posts_NoComments,
SUM(CASE WHEN C.PostId IS NULL THEN 1 ELSE 0 END) / (COUNT(*)) *100 AS Percent_NoComments
FROM Posts P
LEFT JOIN Comments C
ON C.PostId = P.Id

fork query

edited jun 6 23

created jun 6 23 anonymous