By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create table t (Ticket varchar(10), Submit_Date date, Complete_Date date)
Insert into t
Values
('001','05/09/2020','05/09/2020'),
('123','05/13/2020','05/16/2020'),
('456','05/15/2020','05/22/2020'),
('789','05/21/2020','05/23/2020')
;With tCTE as
(select DATEPART(ww,Submit_Date) as wkNumSubmit, DATEPART(ww,Complete_Date) as wkNumComplete, * from t)
Select s.*, w.* from
(select wkNumSubmit, Count(distinct Submit_Date) as Submitted from tCTE Group By wkNumSubmit) s
inner join
(select wkNumComplete, Count(distinct Complete_Date) as Worked from tCTE Group By wkNumComplete) w
on s.wkNumSubmit = w.wkNumComplete
| wkNumSubmit | Submitted | wkNumComplete | Worked |
|---|---|---|---|
| 19 | 1 | 19 | 1 |
| 20 | 2 | 20 | 1 |
| 21 | 1 | 21 | 2 |