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

Understanding How to Simulate Read Uncommitted Behavior in Oracle for Better Data Consistency

How to Use Window Functions to Increment Row Numbers Based on Specific Conditions

Retrieving the Next Step in a Process Using SQL Joins and Group By Clause

Understanding Nested Set Attributes in Oracle SQL: Benefits, Drawbacks, and Best Practices for Efficient Querying

Understanding the Impact of Microsoft .NET Framework 4.8 Version 4.8.03761 on Access Database VBA UPDATE SQL Commands: A Guide to Resolving Common Issues

How to Calculate Average Interval Between Rows in a Timestamp Column Using SQL

Understanding SQL Server Connection Pooling and Concurrency Limits for High Performance Database Operations

Understanding the Issue with Subqueries in Oracle Queries Using NOT EXISTS Instead of Not In

How to Replicate the Substitute Function in Excel Using Presto SQL