MariaDB 10.3

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


@@version


10.3.9-MariaDB-1:10.3.9+maria~stretch-log


CREATE TABLE receta(
   id_receta INT PRIMARY KEY AUTO_INCREMENT,
   nombre VARCHAR(20) NOT NULL,
   precio DECIMAL(3, 1)
);
INSERT INTO receta(nombre, precio)
VALUES
("torta", 35.0),
("pay de limón", 15.0),
("ensalada", 40.0),
("sopa", 25.0),
("chocolate", 20.0);
CREATE TABLE ingrediente(
  id_ingrediente INT PRIMARY KEY AUTO_INCREMENT,
  nombre varchar(20)
);
insert into ingrediente(nombre)
values
("huevo"),
("harina"),
("galletas"),
("limón"),
("leche evaporada"),
("leche"),
("azúcar"),
("jamón"),
("mayonesa"),
("bolillo"),
("sal");
CREATE TABLE receta_ingrediente(
  id_receta_ingrediente int primary key auto_increment,
  id_receta int not null,
  id_ingrediente int not null,
  CONSTRAINT fk_receta_ingrediente_receta foreign key(id_receta) references receta(id_receta),
  CONSTRAINT fk_receta_ingrediente_ingrediente foreign key(id_ingrediente) references ingrediente(id_ingrediente)
);
insert into receta_ingrediente(id_receta, id_ingrediente)
values
(1, 8),
(1, 9),
(2, 4),
(2, 6),
(2, 7),
(4, 11),
(5, 6),
(5, 7),
(4, 6);
SELECT DISTINCT(receta.nombre)
from receta
join receta_ingrediente
on receta.id_receta = receta_ingrediente.id_receta
WHERE 
(receta_ingrediente.id_ingrediente IN (6,7))
AND receta.nombre <> "sopa";


nombre


pay de limón

chocolate