Write SQL

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%