Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools
SELECT COUNT(U.ID) AS UserCount, COUNT(P.ID) AS PostUserCount FROM Users U JOIN Posts P ON U.Id = P.OwnerUserId --WHERE P.OwnerUserId IS NULL;