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 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