dynamic case, MySQL

Language: Layout:

drop table if exists tabla_a;
drop table if exists parametros_venta1;

create table tabla_a (
  id int auto_increment not null primary key,
  a int not null,
  b int not null,
  c int not null,
  d int not null    
);

insert into tabla_a (a,b,c,d)
values
(10,10,10,10),
(15,15,15,15),
(20,20,20,20),
(25,25,25,25),
(30,30,30,30),
(40,40,40,40),
(45,45,45,45),
(50,50,50,50),
(55,55,55,55);

create table parametros_venta1 (
  id int auto_increment not null primary key,
  minimo int not null,
  maximo int not null,
  valor int not null
);

insert into parametros_venta1 (minimo, maximo, valor)
values
(15, 25, 1),
(25, 30, 2),
(30, 45, 3),
(45, 50, 4);

select a, b, c, d,
       coalesce((select p.valor
                   from parametros_venta1 p
                  where t.a >= p.minimo
                    and t.a < p.maximo), 0) as indicador
  from tabla_a t
 order by id;

select t.a, t.b, t.c, t.d,
       coalesce(p.valor, 0) as indicador
  from tabla_a t
  left join parametros_venta1 p
    on t.a >= p.minimo
   and t.a < p.maximo
 order by t.id;

drop table tabla_a;
drop table parametros_venta1;


absolute service time: 0,37 sec