Untitled-Notepad File Edit Format View Help 6. L?stt the employee last name and

Question

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

Explanation / Answer

Assumptions – As the question does not mention the table names, I have assumed table names based on the column details provided. You have to change the table names to the actual ones based on your question.

6. select employee_lastname, sum (transaction_value) from employee_table where sum (transaction_value) > $30.00;

7. select supplier_ID,supplier_company,sum(food_price) from companies_table where sum(food_price) > $9000;

8. select payment_ID, sum(payment_amount) from payment_table where payment_amount > $5000 group by payment_ID;

9.select department_ID, max (salary) as highest_salary from department_table where max (salary) > $55000;

10.select distinct food_description from fooditems_table where count(food_items) > 150;

11. select employee_firstname, employee_lastname, employee_phone from employee_table where employee_salary <=$20000 order by employee_lastname;

12. select * from department_table order by department_name;

13. select employee_ID, employee_firstname, employee_lastname from employee_table where employee_office = 'Aquatic Research';

14. select name,ID from polarbears;

15. select name, gender, breed, habitat, checkup_height from animal_table where gender = 'Female' and source = 'Como Zoo';

16. select food_items from fooditems_table where consumer = 'Jack';

17. select sponsor_name, sponsor_amount from sponsor_table where sponsor_month = 'July' and sponsor_year = '2008' and sponsor_amount > $2000;

18. select donator_lastname,donator_payment_date, payment_type,payment_amount, zoo_name from donator_table order by donator_lastname;

19. select employee_ID, employee_office, department_name,certification_status from employee_table;

20. select name, food_description, dietary_req, cost_diet from animal_table where animal_type = 'Cheetah';

21. select employee_firstname, employee_lastname employee_office, department_name,zoo_name from employee_table where employee_office IS NOT NULL and department_name IS NOT NULL;

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.