(Solved): 9&10 revision Write an SQL statement for the questions, to clarify I've provided the table : ...

9&10 revision

Write an SQL statement for the questions, to clarify I've provided the table :)

Display both ordered and un-ordered products. Display product ID, product description, and order ID in the category 'MUS' Question 10 Display customers with and without orders. Display customer ID, last name, and order ID. We get customers with orders. If the customer has several orders, that customer gets multiple lines in the result set. We also get rows for the two customers in this cust_id range who have no orders and the column for their order ID value is null-these customers each get one row.