Question: Item table table [ [ ITEM _ ID , DESCRIPTION,ON _ HAND,CATEGORY,LOCATION,PRICE ] , [ AD 7 2 , Dog Feeding Station, 1 2

Item table
\table[[ITEM_ID,DESCRIPTION,ON_HAND,CATEGORY,LOCATION,PRICE],[AD72,Dog Feeding Station,12,DOG,B,79.99],[BC33,,10,BRD,B,79.99],[CA75,Enclosed Cat Litter Station,15,CAT,C,39.99],[DT12,Dog Toy Gift Set,27,DOG,B,39.99],[FM23,Fly Mask with Ears,41,HOR,C,24.95],[FS39,Folding Saddle Stand,12,HOR,C,39.99],[FS42,Aquarium (55 Gallon),5,FSH,A,124.99],[KH81,Wild Bird Food (25 lb),24,BRD,C,19.99],[LD14,Locking Small Dog Door,14,DOG,A,49.99],[LP73,Large Pet Carrier,23,DOG,B,59.99],[PF19,Pump ??& Filter Kit,5,FSH,A,74.99],[QB92,Quilted Stable Blanket,32,HOR,C,119.99],[SP91,Small Pet Carrier,18,CAT,B,39.99],[UF39,Underground Fence System,7,DOG,A,199.99],[wann,1dots,74,unn,-,mann]]
Invoice_line
\table[[INVOICE_NUM,ITEM_ID,QUANTITY,QUOTED_PRICE],[14216,CA75,3,37.99],[14219,AD72,2,79.99],[14219,DT12,4,39.99],[14222,LD14,1,47.99],[14224,KH81,4,18.99],[14228,FS42,1,124.99],[14228,PF19,1,74.99],[14231,UF39,2,189.99],[14233,KH81,1,19.99],[14233,QB92,4,109.95],[14233,WB49,4,74.95],[14237,LP73,3,54.95]](Subquery)
List the invoice numbers that contain an invoice line for an item in category HOR.
Item table \ table [ [ ITEM _ ID , DESCRIPTION,ON

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 Programming Questions!