0

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;
2
Contributors
2
Replies
9
Views
3 Years
Discussion Span
Last Post by <M/>
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.