-stion 2 Refer the table given below to answer the following questions. yet wered Write the function to calculate the following: rked out of 00 a. Total no. of product sold in Paper sub-category Flag question b. Count of orders starting with AZ-2011 c. What is the total sale of furniture category? d. Total order where profit is negative e. Total amount of returned product d. Total order where profit is negative e. Total amount of returned product G A B D E 1 Order ID Product Name Discount Sales Profit Quantity Category Sub-Category Return Status 2 BN-2011-7407039 Enermax Note Cards, Premium 0.5 $45.00 -$26.00 3 Office Supplies Paper Sold 3 AZ-2011-9050313 Dania Corner Shelving, Traditional 0 $854.00 $290.00 7 Furniture Bookcases Sold 4 AZ-2011-6674300 Binney & Smith Sketch Pad, Easy-Erase $140.00 $21.00 3 Office Supplies Art Sold 5 BN-2011-2819714 Boston Markers, Easy-Erase 0.5 $27.00 -$22.00 2 Office Supplies Art Returned 6 BN-2011-2819714 Eldon Folders, Single Width 0.5 $17.00 -$1.00 2 Office Supplies Storage Returned 7 AZ-2011-617423 Binney & Smith Pencil Sharpener, Water Color 0 $90.00 $2100 3 Office Supplies Art Sold 8 AZ-2011-617423 Sanford Canvas, Fluorescent $207.00 $77.00 4 Office Supplies Art Sold 9 AZ-2011-2918397 Bush Floating Shelf Set, Pine 0.1 $155.00 $36.00 1 Furniture Bookcases Sold 10 AZ-2011-2918397 Accos Thumb Tacks, Assorted Sizes $33.00 $2.00 3 Office Supplies Fasteners Sold 11 AZ-2011-2918397 Smead Lockers, Industrial $716.00 $143.00 4 Office Supplies Storage Sold 12 BN-2011-3248724 Ikea Classic Bookcase, Metal 0.6 $987.00 -$1,012.00 6 Furniture Bookcases Sold 13 BN-2011-3248724 Binney & Smith Sketch Pad, Blue 0.5 $116.00 -$56.00 5 Office Supplies Art Sold 14 AZ-2011-7053593 SAFCO Executive Leather Armchair, Red 0 $1,384.00 $14.00 3 Furniture Chairs Sold 15 AZ-2011-7053593 Binney & Smith Canvas, Blue 0 $103.00 $20.00 2 Office Supplies sold 16 AZ-2011-6439906 Bevis Training Table, with Bottom Storage 0.6 $268.00 -$342.00 2 Furniture Tables Sold 17 AZ-2011-4827146 Boston Canvas, Fluorescent 0 $55.00 $10.00 11 office Supphes Art Sold 18 AZ-2011-4827146 Smead Trays, Single Width 0 $97.00 $31.00 2 Office Supplies Storage Sald 19 AZ-2011-6439906 Novimex File Folder Labels, Alphabetical 0 $40.00 $600 5 Office Supplies Labels Sold 20 AZ-2011-6712797 Ibico Hole Reinforcements, Recycled 0 $22.00 $7.00 3 Office Supplies Binders Sold 21 AZ-2011-2222024 Green Bar Note Cards, Multicolor 0.5 $34.00 -S600 2 Office Supplies Paper 0 Hon Chairmat, Adjustable 22 AZ 2011-9927716 $290.00 $70.00 5 Furniture Chais Sold ikea Stackable Bookrack, Traditional 23 AZ-2011-5702370 0.1 $552.00 $165 00 s Furniture Solat Bookcases $257.00 S Office Supplies Art 24 AZ-2011-5702370 $49.00 sold Binney 8. Smith Canvas, Blue $600 $17.00 bico Index Tab, Clear 2 Office Supplies Binders Sold 25 AZ-2011-5702370 ol 26 AZ 2011.5702870 Epson Printer White $522.00 $21001 2 Technology Machines Sold sold ToOo