Compose a query to find vendors who supply Red Oak with grade C-4
business
Description
Compose a query to find vendors who supply Red Oak with grade C-4. In the result table, showvendor name, material description, grade, and the supplier’s unit price for Read Oak with grade C-4.Sort the result by unit price in ascending order.
9. The management would like to know which order that produced the highest total sales amount (indollars). In the result table, show the order ID and its corresponding total sales amount as well as thecustomer name who submitted that order.
2 problems. I need 2 SQL queries.
