Grouping Rows in SQL While Calculating Average Based on Certain Conditions

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