sql statement

1. For Orders placed by customers from Boston that include Cat Food items, retrieve the order IDs, customer names and the total amount of orders. (label the total amount of orders as OrderTotal)

tabes (pictures): 1. customers 2. orderitem 3.order 4. employee 5. Inventory

i dont know how to add the file in so that was the best i could do post up the tables

| Filter Tr Total rows loaded CID Name Address City State Zip Category Celine Dion Charlie Peacock Jim Brickman Leon Redbone Marvin Matthews 234 Sandy Ln # 128 Springfield IL Ray Boltz Stephen C. Chapman 12 Oakwood Suite 234 BostonMA Warren Hill 143 Canada Way 23 Paris Ln 787 Sureway 2934 Simon Dr. Boston MA 62302 FLO Ft. Worth TX 76132 FLO Boston MA 62320 WALK Springfield IL 12364 FLO 12354 WALK 333 Ziptree Boston MA 62301 WALK 62310 GOV 324 East 7th Boston MA 62301 GOV