Error on Query

[<M/>]

I wrote 2 queries and I am not sure what is wrong with them.

Can someone tell me what to do in order to fix them?

#T8
select sum( quantity ) * (select price from fruit where name like 'apple')
from inventory
where fruitID=(select fruitID from fruit where name like 'apple');

#T9
select price*sum( quantity ) from fruit as f, inventory as i where f.fruitID = i.fruitID group by i.fruitID;

[pritaeas]

Technically nothing. It seems you didnt read my reply in your other thread.

[<M/>]

hmmmm, i think i forgot about that thread... let me read it.