MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table table1 as
    select 1 as id_table1, 1234 as ean, '2020-01-01' as date_from, '2021-01-01' as date_to, 'blue' as type, 'big' as region, 20000 as consumption union all
    select 2 as id_table1, 5678 as ean, '2020-01-01' as date_from, '2021-01-01' as date_to, 'blue' as type, 'big2' as region, 80000 as consumption union all
    select 2 as id_table1, 6845 as ean, '2020-01-01' as date_from, '2021-01-01' as date_to, 'white' as type, 'small' as region, 10000 as consumption 
create table table2 as
    select 1 as id_table2, '2020-01-01' as day, 1 as hour, 0.011120 as type_blue_big_coefficient, 0.32652 as type_blue_big2_coefficient, 0.054165 as type_white_coefficient union all
    select 2 as id_table2, '2020-01-01' as day, 2 as hour, 0.023265, 0.12543, 0.054165
select t1.ean, t2.day, t2.hour,
       sum(case when t1.type = 'blue' and region = 'big' then t2.type_blue_big_coefficient * t1.consumption
                when t1.type = 'blue' and region = 'big2' then t2.type_blue_big2_coefficient * t1.consumption
                when t1.type = 'white' then t2.type_white_coefficient * t1.consumption
                else 0
           end) as consumption                
from table1 t1 join
     table2 t2
     on t2.day >= t1.date_from and t2.day <= t1.date_to
group by t1.ean, t2.day, t2.hour;


ean
day
hour
consumption


1234
2020-01-01
2
465.300000

1234
2020-01-01
1
222.400000

5678
2020-01-01
2
10034.400000

5678
2020-01-01
1
26121.600000

6845
2020-01-01
2
541.650000

6845
2020-01-01
1
541.650000

ean	day	hour	consumption
1234	2020-01-01	2	465.300000
1234	2020-01-01	1	222.400000
5678	2020-01-01	2	10034.400000
5678	2020-01-01	1	26121.600000
6845	2020-01-01	2	541.650000
6845	2020-01-01	1	541.650000