Zoo Questions 4 IT340 6CSecure https://mnsu.learn.minnstate.edu/d2l/le/content/3971347/viewContent/34139735/View Zoo Questions 4 The purpose of this assignment to understand simple SQL statements and answer questions based on the Zoo database schema Assignment Requirement:s Run the Zoo database's "FULL DATABASEwith DROP" script to create the tables and insert data for these questions. Questions 1 Find the difference between the food item with the maximum price and the food Lettl with the ItILIILIt1u1tl price. 2. What is the range of payments from corporate sponsors? 3. What is the maximum pay amount rom a credit card? Only show the max amount from a Visa credit card 4. T.st the gender and how many animals there are of each gender 5. Lst each prvale ever!ype and the surus of their prices 6. List the employee last name and the sum of the transactions made by oach omployoc. Rostrict tho output to thoso omploycos whoro Type here to search 1013 PM 4/212018