CREATE TABLE temp AS
SELECT
                id_prod ,
                year as order_year,
                
                total_sales as current_sales,
                sum(total_sales) OVER (partition by id_prod order by year 
                                        ROWS BETWEEN 3 preceding AND 1 preceding ) total_sales_3lag,

FROM tmp_table ;