using mysql

1. How many customers have placed an order?

(Hint: count a customer one time if the customer has multiple orders)

2. List the names (customer name, not contact names) of all customers who have placed an order.

(Hint: list a customer one time if the customer has multiple orders)

3. List the names of all customers who have not placed an order.

(Hint: this is an anti-join

4. List all customer orders where the order has not been Cancelled. Include the order number, order date, order status and customers name.
5. List all customers names with each product that customer has ordered. Include customers who do not have an order. Include the product name of the item ordered. If a customer has ordered the same product multiple times, only list the product once for that customer.

(Hint: you will need to join 4 tables.)

off eCode VARCHAR(10) city: VARCHARS0) phone: VARCHAR(S0) addinessline l: VARCHAR(SO) orderlumber INTEGER orderNumber: INTEGER productCode: VARCHARC5) 9 orderOute DATETIME MALLINT comments: TEXT customer% mber INTEGER country: VARCHARSO) postalCode VARCHARIS) sales Repltmplyeeumber: INTEGER productcode: VARCHAR(25) productName: VARCHAR70 VARCHAR(10) 9 extension: VARCHARO) produenendor. VARCHAR(50) ARCHAR(SO) quastylaStock INTEGER 0 buy Price: DOUBLE