Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete using proc sql; procedure in s as 3. Using the EXCEPT Operator to Count Rows Create a report that displays the total count

Please complete using proc sql; procedure in s as

image text in transcribed

image text in transcribed

3. Using the EXCEPT Operator to Count Rows Create a report that displays the total count of employees who did not make any charitable donations. The orion.Employee_organization table contains a record for every employee in the Orion Star organization and includes the employee identification numbers. Th orion. Employee_ donations table contains records only for employecs who made charitable donations, including the Employee_ID value. PROC SQL Output No Employees w No Charitable Donations 300 4. Using the INTERSECT Operator to Count Rows Create a report that shows the total number of customers who placed orders. The orion.Order fact table contains information about the orders that were placed by Orion Star customers, including Customer ID. The orion. Customer table contains information on all Orion Star customers, including Customer_ID PROC SQL Output No Customers w Orders 75 3. Using the EXCEPT Operator to Count Rows Create a report that displays the total count of employees who did not make any charitable donations. The orion.Employee_organization table contains a record for every employee in the Orion Star organization and includes the employee identification numbers. Th orion. Employee_ donations table contains records only for employecs who made charitable donations, including the Employee_ID value. PROC SQL Output No Employees w No Charitable Donations 300 4. Using the INTERSECT Operator to Count Rows Create a report that shows the total number of customers who placed orders. The orion.Order fact table contains information about the orders that were placed by Orion Star customers, including Customer ID. The orion. Customer table contains information on all Orion Star customers, including Customer_ID PROC SQL Output No Customers w Orders 75

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students also viewed these Databases questions

Question

=+. Does it speak from the audience's point of view?

Answered: 1 week ago

Question

=+ a. How does this change affect the incentives for working?

Answered: 1 week ago