Oracle 11g Release 2

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

with Your_Table_name(ID, update_Date, code, address1, address2, city, state_code, zip_code) as (
  select 1, to_date('2023/02/15', 'YYYY/MM/DD'), 'CO', 'Apt 320',   null, 'NYC', 'NY', 10012 from dual union all
  select 1, to_date('2021/12/03', 'YYYY/MM/DD'), 'CO', 'Apt 105',   null, 'NYC', 'NY', 10012 from dual union all
  select 1, to_date('2023/02/15', 'YYYY/MM/DD'), 'WK', '5th Avenue',  null, 'NYC', 'NY', 10012 from dual union all
  select 2, to_date('2023/02/15', 'YYYY/MM/DD'), 'CO', 'Apt 325',   null, 'NYC', 'NY', 10012 from dual union all
  select 2, to_date('2022/01/12', 'YYYY/MM/DD'), 'CO', 'Apt 123',   null, 'NYC', 'NY', 10012 from dual union all
  select 2, to_date('2023/02/14', 'YYYY/MM/DD'), 'WK', '4th Avenue',  null, 'NYC', 'NY', 10012 from dual union all
  select 2, to_date('2021/02/11', 'YYYY/MM/DD'), 'WK', '5th Avenue',  null, 'NYC', 'NY', 10012 from dual
)
SELECT ID,
       REGEXP_REPLACE(MAX(ADDRESS1) /* WK code road_name */
                         KEEP(DENSE_RANK FIRST ORDER BY
                           DECODE(CODE, 'WK', 1, 2) ASC,
                           UPDATE_DATE DESC) || ', ' || 
                      MAX(ADDRESS1) /* CO code apartment number */
                         KEEP(DENSE_RANK FIRST ORDER BY
                           DECODE(CODE, 'CO', 1, 2) ASC,
                           UPDATE_DATE DESC) || ', ' || 
                      MAX(ADDRESS2)
                         KEEP(DENSE_RANK FIRST ORDER BY
                           DECODE(CODE, 'WK', 1, 2) ASC,
                           UPDATE_DATE DESC) || ', ' || 
                      MAX(CITY)
                         KEEP(DENSE_RANK FIRST ORDER BY
                           DECODE(CODE, 'WK', 1, 2) ASC,
                           UPDATE_DATE DESC) || ', ' || 
                      MAX(STATE_CODE)
                         KEEP(DENSE_RANK FIRST ORDER BY
                           DECODE(CODE, 'WK', 1, 2) ASC,
                           UPDATE_DATE DESC) || ', ' || 
                      MAX(ZIP_CODE)
                         KEEP(DENSE_RANK FIRST ORDER BY
                           DECODE(CODE, 'WK', 1, 2) ASC,
                           UPDATE_DATE DESC)
                 , '(,[[:space:]])(,)'
                 , '\2'
              ) AS TENANT_ADDRESS
  FROM YOUR_TABLE_NAME T
 GROUP BY ID;

ID	TENANT_ADDRESS
1	5th Avenue, Apt 320, NYC, NY, 10012
2	4th Avenue, Apt 325, NYC, NY, 10012