Untitled-Notepad File Edit Format View Help 6. L?stt the employee last name and the sum of the transactions made by each employee. Restrict the output to those employees where their total sum of transactions is more than $30.00. 7. List the food supplier ID, supplier company name and the sum of the food price for the companies that have a food price sum greater than 9880 8. List the payment ID and sum of the payment amount. Group by payment ID and list only those that have a payment amount of more than 5e80 9. List each department ID and the highest salary of all departments with a max salary of over 55,88 10. Display the description of all of the food items that have more than 150 items on hand. Do not list a description more than once 11 .Find all of the employee first name, last name, and phone number for all employees that make at most $2080 a year. Order the results by employee last name. 12. Show all information from department table and order it by department name. 13. List the employee id, first name, and last name of the employees that work in an office building called Aquatic Research 14. List the name and id of all the Polar Bears. 15. List the name, gender, breed, habitat and checkup height of al1 animals who are female and are acquired from Como Zoo. 16. List the food item(s) "Jack" eats. 17. List the names of the sponsor companies that donated in July of 2088. Also list the amount donated, but limit your results with those sponsors who donated more than 2000 18. List the donator's last name, donator payment date, payment type, payment amount and zoo name. Order the output by donator's last name 19. List the employees' ID, office building, department name, and if they're keeper certified. 20. For all cheetahs, find their name, food description, dietary requirements and the cost of the dietary requirement. 21. select the employee first name, last name, office building, department name, zoo name for every researcherthat has an office building and a department. 1:59 AM Tvpe here to search 4/22/2018