Combine two queries

Hey tbumbray, have you tried using the union operator to join both queries?

with cte as (
select ID,
assessmentdate,
Jurisdiction,
name,
studentid,
submitdate,
count(*) over (partition by studentid) as dup_count
from tblTest
)
Select m.assessmenttype, Count(m.studentid) As referredforassessment
From tblProfile m
Inner Join cte s on
m.studentid = s.studentid
Where dup_count > 1
and s.SubmitDate between '06/01/2024' and '06/30/2024'
and countyid = 6
Group by assessmenttype
--Order by assessmenttype
union
select assessmenttype,
SUM(CASE WHEN referredforassessment = 1 THEN 1 ELSE 0 END) as referredforassessment
from tblProfile
where SUBMITDATE >= '06/01/2024' and SUBMITDATE < '06/30/2024' and countyid = 6
Group By assessmenttype
order by assessmenttype