By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[_abc](
[wage] [int] NULL
) ON [PRIMARY]
INSERT INTO [dbo].[_abc]
(wage)
VALUES
(4),
(8),
(15),
(30),
(50)
select sum(wage) sum_of_all_wages
, count(1) count_of_all_records
from [dbo].[_abc]
having sum(wage) > 5
select *
from [dbo].[_abc]
where wage > 5
select sum(wage) sum_of_wage_over_5
from [dbo].[_abc]
where wage > 5
select case when wage > 5 then 1 else 0 end wage_over_five
, sum(wage) sum_of_wage
from [dbo].[_abc]
group by case when wage > 5 then 1 else 0 end
| sum_of_all_wages | count_of_all_records |
|---|---|
| 107 | 5 |
| wage |
|---|
| 8 |
| 15 |
| 30 |
| 50 |
| sum_of_wage_over_5 |
|---|
| 103 |
| wage_over_five | sum_of_wage |
|---|---|
| 0 | 4 |
| 1 | 103 |