Rewrite 2 very small SQL Queries - SQL Server 2019

I got 2 queries to fix. It would be 7-10 lines query. Its a 10-15 minutes project if you are good with query that require "JOINT" and "WHERE" statement