SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

--Assume all posts are for the same user
CREATE TABLE dbo.Posts (Id int IDENTITY(1, 1),
                        Score int
                            DEFAULT 0,
                        CreationDate datetime2(1)
                            DEFAULT SYSDATETIME(),
                        ClosedDate datetime2(1),
                        DeletionDate datetime2(1));
INSERT INTO dbo.Posts (Score,
                       CreationDate,
                       ClosedDate,
                       DeletionDate)
VALUES (3, '20220101', NULL, NULL), --Positive Question
       (1, '20220201', NULL, NULL), --Positive Question
       (0, '20220301', NULL, NULL), --Not Negative Question
       (-2, '20220401', '20220402', NULL), --Negative, Closed
       (-3, '20220501', '20220502', '20220503'), --Negative, Closed, Deleted
       (-1, '20220601', NULL, '20220605'), --Negative, Deleted
       (0, '20220701', NULL, '20220717'), --Not negative, Deleted
       (-1, '20220801', NULL, NULL); --Negative, not deleted
8 rows affected

SELECT *
FROM dbo.Posts;


Id
Score
CreationDate
ClosedDate
DeletionDate


1
3
2022-01-01 00:00:00.0
null
null

2
1
2022-02-01 00:00:00.0
null
null

3
0
2022-03-01 00:00:00.0
null
null

4
-2
2022-04-01 00:00:00.0
2022-04-02 00:00:00.0
null

5
-3
2022-05-01 00:00:00.0
2022-05-02 00:00:00.0
2022-05-03 00:00:00.0

6
-1
2022-06-01 00:00:00.0
null
2022-06-05 00:00:00.0

7
0
2022-07-01 00:00:00.0
null
2022-07-17 00:00:00.0

8
-1
2022-08-01 00:00:00.0
null
null


WITH
Counts AS
    (SELECT COUNT(*) AS Total,
            SUM(CASE WHEN Score < 0 THEN 1 ELSE 0 END) AS Negative,
            SUM(CASE WHEN Score > 0 THEN 1 ELSE 0 END) AS Positive,
            SUM(CASE
                     WHEN ClosedDate IS NOT NULL
                      AND DATEDIFF(DAY, CreationDate, ClosedDate) < 60 THEN 1
                     ELSE 0
                END) AS Closed,
            SUM(CASE
                     WHEN DeletionDate IS NOT NULL
                      AND DATEDIFF(DAY, CreationDate, DeletionDate) < 60 THEN 1
                     ELSE 0
                END) AS Deleted
     FROM dbo.Posts)
SELECT Total,
       Negative,
       Positive,
       Closed,
       Deleted,
       CAST(Total - Negative - Closed - Deleted AS float) / Total AS Ratio,
       CAST((CASE WHEN CAST(Total - Negative - Closed - Deleted AS float) /Total >= .5 THEN 1 ELSE 0 END) AS bit) AS HasGoodRecord
FROM Counts;


Total
Negative
Positive
Closed
Deleted
Ratio
HasGoodRecord


8
4
2
2
3
-0.125
False


DROP TABLE dbo.Posts;

Id	Score	CreationDate	ClosedDate	DeletionDate
1	3	2022-01-01 00:00:00.0	null	null
2	1	2022-02-01 00:00:00.0	null	null
3	0	2022-03-01 00:00:00.0	null	null
4	-2	2022-04-01 00:00:00.0	2022-04-02 00:00:00.0	null
5	-3	2022-05-01 00:00:00.0	2022-05-02 00:00:00.0	2022-05-03 00:00:00.0
6	-1	2022-06-01 00:00:00.0	null	2022-06-05 00:00:00.0
7	0	2022-07-01 00:00:00.0	null	2022-07-17 00:00:00.0
8	-1	2022-08-01 00:00:00.0	null	null