xmldeveloper:

Interogarea originala este:

SELECT
C.numeComponenta,
R.gramaj,
D.pretComponentaPerKg
FROM pizza AS P,
reteta AS R,
componente AS C,
CostComponente AS D
WHERE
P.idPizza=R.idPizza
And r.idcomponenta=c.idcomponenta
And C.idComponenta=D.idComponenta
and p.tippizza='capriciosa';

Un posibil raspuns este:

SELECT
C.numeComponenta,
R.gramaj,
D.pretComponentaPerKg,
(R.gramaj * D.pretComponentaPerKg)/1000 AS Price
FROM pizza AS P,
reteta AS R,
componente AS C,
CostComponente AS D
WHERE
P.idPizza=R.idPizza
And r.idcomponenta=c.idcomponenta
And C.idComponenta=D.idComponenta
and p.tippizza='capriciosa';

...aici cred ca trebuie sa selectezi si o reteta anume - se pare ca pentru "capriciosa" exista mai multe retete (???).