The final answer is:

Understanding how to Convert Dates to Strings in Oracle PL/SQL: Best Practices and Examples

Understanding Business Days in Oracle Queries: A New Approach Using TRUNC and ISO Week Numbers

Joining Two Tables and Getting the Most Recent Records for a Given Name: A SQL Solution Using Correlated Subqueries

Understanding Foreign Key Constraints in Oracle: A Deep Dive

Updating Rows in an Oracle Database: A Conditional Update Solution Using SQL Queries