Using Common Table Expressions (CTEs) in Oracle: Simplifying Updates with Derived Tables and MERGE Statement

Understanding Oracle Date Functions and Conditional Logic Issues

Understanding Distinct Queries with Oracle in Depth

Resolving ORA-01722 Errors: Best Practices for Converting VARCHAR2 Columns to NUMBER

I can help with some of the issues you're facing.

Understanding Oracle's Aggregate Function Ordering Behavior: When Average Goes Wrong with Group By Clauses