Question

Member balance memberld name address 1 Brooks, B. 7 Apple Rd $10.50 2 Field, W 43 Cherry Lane $0.00 3 Jones, A. 43 Cherry Lane $155.65 4 Robin, R. 12 Heather St.($123.45) 5 Hart, W 65 Lark Rd. ($43.00)
  

Answer 1

Solution 1) Translated English statement for given query Display the member name, quantity of member which the member id is placed in both order table and item table where the name of item is 'Lettuce' 2) Output of given query: NAME QUANTITY Robin,R Queiry using SQL join syntax: select member.name,quantity from ( (member inner join orderr on member.memberId=orderr.memberIdFK) inner join item on orderr.itemIdFK=item.itemId and itemName='Lettuce'); Output of above query: NAME QUANTITY Robin,R 8 3) select member.name,address from member where memberId in (select memberIdFK from orderr where itemIdFK in (select itemId from item where itemName='Sunflower Seeds')); Output of above query:

NAME ADDRESS Robin,R 12 Heather St Jones,A 43 Cherry Lane 4) Output of given query NAME ADDRESS Jones,A 43 Cherry Lane Robin,R 12 Heather St