Question: SQL Query Question: This is using the PVFC database, so if you have it, please use it. Provide a list of raw materials and quantities

SQL Query Question: This is using the PVFC database, so if you have it, please use it.

SQL Query Question: This is using the PVFC database, so if you

have it, please use it. Provide a list of raw materials and

Provide a list of raw materials and quantities required to produce one cherry end table and one oak computer desk (products with product descriptions 'cherry end table' and 'oak computer desk'). Each raw material required should be listed only once. The query should output the material ID, material name, material standard price, and total quantity of raw material required (to produce one cherry end table and one oak computer desk). Sort the results with the most expensive raw materials listed first. So far I have this: select rawmaterial_t.materialid, rawmaterial_t.materialname, rawmaterial_t.materialstandardprice, uses t.quantityrequired from product t, uses t, rawmaterial _t where product t.productid-uses t.productid and uses_t.materialid rawmaterial_t.materialid and product t.productdescription 'cherry end table' order by rawmaterial_t.materialstandardprice desc How do I make sure this also covers the oak computer desk? Provide a list of raw materials and quantities required to produce one cherry end table and one oak computer desk (products with product descriptions 'cherry end table' and 'oak computer desk'). Each raw material required should be listed only once. The query should output the material ID, material name, material standard price, and total quantity of raw material required (to produce one cherry end table and one oak computer desk). Sort the results with the most expensive raw materials listed first. So far I have this: select rawmaterial_t.materialid, rawmaterial_t.materialname, rawmaterial_t.materialstandardprice, uses t.quantityrequired from product t, uses t, rawmaterial _t where product t.productid-uses t.productid and uses_t.materialid rawmaterial_t.materialid and product t.productdescription 'cherry end table' order by rawmaterial_t.materialstandardprice desc How do I make sure this also covers the oak computer desk

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!