The Orion.employee_donations table is Challenge 7. Subsetting Data Using the ESC

Question

The Orion.employee_donations table is
Challenge 7. Subsetting Data Using the ESCAPE Clause Create a report that displays the Employee ID and Recipients for all employees who contributed 90% of their charitable contributions to a single company that was incorporated (Inc.) and is the last recipient in the list to receive the 90% contribution. Use the donations table. Hint: Use the ESCAPE clause in the WHERE clause to solve this problem Alternative methods can be used to solve this problem, but for this exercise, use the LIKE operator with an ESCAPE clause. PROC SQL Output Employee ID Recipients 120783 Disaster Assist Inc. 10%, Cancer Cures Inc. 90% 121012 child survivors 10%, Disaster Assist Inc. 90% 121136 Disaster Assist Inc. 10%, cancer cures, Inc. 90%

Explanation / Answer

SELECT Employee_Id,Recipients FROM Orion.employee_donations
where ((qtr1+qtr2+qtr3+qtr4)/4)*100 > 90% AS QTR

  

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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