Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions