Need SQL server 2019 code updated

Job ID: 32836042

Budget: $10 – $30 CAD

I have 2 short codes thats need to be updated with an inner joint and where statement.
The code actually work but you have to add an inner joint and where to make it done
Related categories: SQL Microsoft SQL Server