################################################################################ # SELECT [FeedTypeID], [FeedName], [AmountInStock], [Supplier], [AmountOrdered] FROM [ZooDB].[qa_usr].[tblAnimalFeed]; # FeedTypeID int # FeedName varchar (50) # AmountInStock varchar (50) # Supplier int # AmountOrdered varchar (50) ################################################################################ FeedTypeID,FeedName,AmountInStock,Supplier,AmountOrdered, ,bananas,200,8,100, ,apples,300 pounds,8,0, ,lettuce,50 heads,8,100 heads, ,carrots,75 pounds,8,150 pounds, ,mice,185,6,0, ,Grade A Fancy Fish Food,150 pounds,7,0, ,eggs,8 dozen,1,10 dozen, ,mealworms,17 pounds,3,0, ,hay,1400 pounds,5,0, ,salt licks,7,1,0, ,fresh fish,450 pounds,5,500 pounds, ,avocados,60,4,50, ,dog kibble,350,8,400, ,ground beef,950,1,1000, ,grubs,100 pounds,3,150, ,birdseed,550 pounds,6,0, ,flower nectar,1 gallon,4,0, ,koi pellets,95 pounds,7,0, ,catfish diet,50 pounds,7,0, ,plankton,75 pounds,7,0,