SELECT 'no post', COUNT(*) FROM( SELECT Users.Id FROM Users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chemistry

Q&A for scientists, academics, teachers, and students in the field of chemistry

SELECT
  'no post',
  COUNT(*)
FROM(
  SELECT
    Users.Id
  FROM Users
  LEFT JOIN Posts ON Posts.OwnerUserId = Users.Id
  WHERE Posts.Id IS NULL
  ) sub

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results