SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Charges (IdCharges int IDENTITY(1,1), PRN Varchar(10), Created Date, SeasonCode Varchar(10));

create table Sales (IdSales int IDENTITY(1,1),IdBounty int, PRN Varchar(10));

create table Bounty (IdBounty int IDENTITY(1,1), BountyTran varchar(10));
INSERT INTO Charges VALUES ('111','2023-06-01','10.1'); 
INSERT INTO Charges VALUES ('222','2023-06-02','10.2'); 
INSERT INTO Charges VALUES ('333','2023-06-03','10.3');

INSERT INTO Bounty VALUES ('WWW');
INSERT INTO Bounty VALUES ('DDD');
INSERT INTO Bounty VALUES ('FFF');

INSERT INTO SALES(PRN,IdBounty) VALUES ('111',1);  
INSERT INTO SALES(PRN,IdBounty) VALUES ('222',2);
INSERT INTO SALES(PRN,IdBounty) VALUES ('333',3);
9 rows affected

    declare @StartDate datetime='2023-06-02'

	SELECT
        B.BountyTran AS BountyTran,
        --'C' AS CODE, 
        LEFT(C.SeasonCode, CHARINDEX('.', C.SeasonCode + '.') - 1) AS SCODE
		,max(Created) OVER(order by (select 0)) AS LatestCreated
    FROM 
        dbo.Sales S
    INNER JOIN 
        dbo.Charges C ON S.PRN = C.PRN
    INNER JOIN 
        dbo.Bounty B ON S.IdBounty = B.IdBounty
                     AND C.Created >= @StartDate


BountyTran
SCODE
LatestCreated


DDD
10
2023-06-03

FFF
10
2023-06-03