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

Solving Preceding Grades with LAG Function in Teradata SQL

How to Optimize Data Storage and Performance Using Range Partitioning in Postgres

Finding the Nearest Future Date in MySQL: A Comparison of Approaches

Understanding and Resolving ORA-12505: A Step-by-Step Guide to Oracle Database Connectivity Issues

Understanding SQL Counts from INNER JOIN Multiple DB Tables: Mastering GROUP BY Clauses for Data Aggregation

Database Normalization Techniques: A Comprehensive Guide to Achieving BCNF Form

Optimizing Query Performance with Null Dates in SQL: Strategies for Success

Understanding Schedule-Run Time Queries with Date and Time Conversions

Finding Cumulative Totals with Condition and Group By Using Optimized SQL Queries