Update Data in PostgreSQL's Transfer_product Table Using Order_product Table and Date Range Condition

Grouping Rows in SQL While Calculating Average Based on Certain Conditions