create table productos (
id_producto int primary key,
nombre varchar(40) not null,
categoria varchar(20) not null,
precio decimal(10,2) not null,
stock int not null,
id_proveedor int,
foreign key (id_proveedor) references proveedores(id_proveedor)
);
insert into productos values
(1,"alfajor triple","golocinas",1500,40,2),
(2,"agua mineral 500 ml","bebidas",1200,24,3),
(3,"gaseosa 500 ml","bebidas",1800,30,3),
(4,"galletitas dulces","galletitas",1300,18,1),
(5,"turron","golosinas",600,50,2),
(6,"chupetin","golosinas",300,80,2),
(7,"barra de cereal","snacks",900,25,1),
(8,"jugo en caja","bebidas",100,0,3),
(9,"papas fritas chicas","snacks",2000,12,1),
(10,"chicle de menta","golocinas",400,60,2),
(11,"galletitas de agua","galletitas",1100,15,1),
(12,"medialuna","panificados",800,20,null);
select nombre, categoria, precio
from productos
where +categoria = "golosinas"
  or precio < 1000;