Question: Sample table: orders table [ [ ord _ no , purch _ amt,ord _ date,customer _ id , salesman _ id ] , [

Sample table: orders
\table[[ord_no,purch_amt,ord_date,customer_id,salesman_id],[,-------------,---------,-----------,----------],[70001,150.5,2012-10-05,3005,5002],[70009,270.65,2012-09-10,3001,5005],[70002,65.26,2012-10-05,3002,5001],[70004,110.5,2012-08-17,3009,5003],[70007,948.5,2012-09-10,3005,5002],[70005,2400.6,2012-07-27,3007,5001],[70008,5760,2012-09-10,3002,5001]]
Sample table: customer
\table[[customer_id,cust_name,cIty,I grade,salesman_id],[3002,Nick Rimando,New York,100,5001],[3007,Brad Davis,New York,200,5001],[3005,Graham Zusi,California,200,5002],[3008,Julian Green,London,300,5002],[3004,Fabian Johnson,Paris,300,5006],[3009,Geoff Cameron,Berlin,100,5003],[3003,Jozv Altidor,Moscow,200,5007]]
Using the tables above, how much (purch_amt) has Graham Zusi ordered? Show your work.
 Sample table: orders \table[[ord_no,purch_amt,ord_date,customer_id,salesman_id],[,-------------,---------,-----------,----------],[70001,150.5,2012-10-05,3005,5002],[70009,270.65,2012-09-10,3001,5005],[70002,65.26,2012-10-05,3002,5001],[70004,110.5,2012-08-17,3009,5003],[70007,948.5,2012-09-10,3005,5002],[70005,2400.6,2012-07-27,3007,5001],[70008,5760,2012-09-10,3002,5001]] Sample table: customer \table[[customer_id,cust_name,cIty,I grade,salesman_id],[3002,Nick Rimando,New York,100,5001],[3007,Brad

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!