SQL Server 2022

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

CREATE TABLE #query1 (
  [date] date,
  sold int
)

CREATE TABLE #query2 (
  [date] date,
  Opportunities int
)

insert into  #query1  ([date] ,  sold)
values 
 ('1-1-2023',7)
,('2-1-2023',2)
,('3-1-2023',8)
,('4-1-2023',2)
,('5-1-2023',8)  
,('6-1-2023',6)
,('7-1-2023',3)
,('8-1-2023',3)
,('9-1-2023',6)
,('10-1-2023',3)
,('11-1-2023',5)
,('12-1-2023',2)

insert into  #query2  ([date] ,  Opportunities )
values 
 ('1-1-2023',15)
,('2-1-2023',6)
,('3-1-2023',13)
,('4-1-2023',14)
,('5-1-2023',14)  
,('6-1-2023',17)
,('7-1-2023',20)
,('8-1-2023',8)
,('9-1-2023',14)
,('10-1-2023',3)
,('11-1-2023',13)
,('12-1-2023',3)

select cast(#query1.[date] as varchar) as 'Date', Sold, Opportunities, 
     ( 
       CONCAT(
       cast( 
               cast(Sold as DECIMAL(5,1))
                /
               CAST(Opportunities as DECIMAL(5,1))
               *100
              as DECIMAL(5,1)
           )
           , '%')
     ) as Ratio 
  from #query1 
  inner join #query2 on #query1.[date] = #query2.[date] 
--order by [date];

UNION ALL
  
select 'TOTAL' as 'Date', sum(Sold) as sold, sum(Opportunities) as Opportunities, 
     ( 
       CONCAT ( 
       cast( 
               cast(sum(Sold) as DECIMAL(5,1))
                /
               CAST(sum(Opportunities) as DECIMAL(5,1))
               *100
              as DECIMAL(5,1)

)
                , '%')
     ) as Ratio 
  from #query1 
  inner join #query2  on #query1.[date] = #query2.[date]

Date	Sold	Opportunities	Ratio
2023-01-01	7	15	46.7%
2023-02-01	2	6	33.3%
2023-03-01	8	13	61.5%
2023-04-01	2	14	14.3%
2023-05-01	8	14	57.1%
2023-06-01	6	17	35.3%
2023-07-01	3	20	15.0%
2023-08-01	3	8	37.5%
2023-09-01	6	14	42.9%
2023-10-01	3	3	100.0%
2023-11-01	5	13	38.5%
2023-12-01	2	3	66.7%
TOTAL	55	140	39.3%