Question: Write SQL query that return the purchase agent's name(s) who placed a purchase order (mutual commitment) of the inventory type Big stuff. Hints: Big stuff
Documents Undo Blank Landscape Purchase Order (Mutual Commitment) Event Order PO Dote Promised Dollar Amt RequisitionlDre AgentCys SupplierlDr. 242010 52/20NO 528,450.00 Purchase Requisition (Instigation) Event Maximum Budget Date Requisition) Date for This Purchase Needed Superipu Agent" Supplier 222010 $30,000.00 22010ES E12 Purchase Onder IDMem O Quantity Needed woted Unit Cest POSE Pos6 20 00 535.50 $29 00 550.00 Purchasing Agent Onternal Agent hase Agent ID Telephone 5554914 DateOfairth Oy Berwick 1237 Krkland A E12 Supplier (External Agent Supplier ID My 14, 1960 Telephone Performance Rating oes Favorne Vendor 89054 Ransom Hwy 555-7655Excelent nventery Type Resource Type Hem ID Description UnitOfMeasure Standard Cost List Price Big Suff Huge StuffEach Bow of 6 Box of 12 130 00 36 00 48 00 572.00 96.00 Tiny Stu TIS Fulfiment2 Relationship Purthase Ovder ID Recelving Repert o Write SQL query that return the purchase agent's name(s) who placed a purchase order (mutual commitment) of the inventory type "Big stuff Hints "Big stuff" is a value of Description attribute in the Inventory Type table e You need multiple JOIN operations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
