Question: 1. Create a query that will show the name and value of those items donated to charity. Restrict your output to only show those items

1. 1. Create a query that will show the name and value ofCreate a query that will show the name and value of those items donated to charity. Restrict your output to only show those items that were furniture. Order your output by name. My output looked like the following:

Name value ------------------------- --------------------------------------- Furniture Adult 110.50 Furniture Adult 250.00 Furniture Adult 85.00 Furniture Adult 50.00 Furniture Child 2.99 Furniture Child 2.99 Furniture DR 150.00 Furniture LR 8.00

Auntie B's Antic ERD CUSTOMER OWNER PEOPLE Peoplell CHARITY Peopleld CharitylD Address City City WORKERS PeoplelD Zip Phone Phone TermDate SSN PeopleType ORDERS OrderlD DONATION Donation!D ITEM ItemTypelD Color MaxPrice ORDER ITEM OrderlD OwnerlD ItemID ITEM DONATION ItemlD ITEM TYPE ltemTypelD ITEM PICKUP Date

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!