0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT
  (
    SELECT COUNT(*) AS PostCount
    FROM PostsWithDeleted
    WHERE PostTypeId = 1 --question
    AND DeletionDate IS NOT NULL
  ) + 
  (

    SELECT COUNT(*) AS PostCount
    FROM Posts
    WHERE PostTypeId = 1 --question
  ) AS TotalQuestions

fork query

edited sep 29 23

created sep 29 23 Timmy Jim