What are the name and address of the customer who placed order number 1006?

Hint: use join operation to combine customer_t and order_t

2. Assemble all information(All customer information, order ID, order date, order quantity, product description, standard price ) necessary for an invoice for order number 1006. (hint: use Join operation)

Hint: use join operation to combine customer_t , order_t, order_line_t and product_t

3. Get the customer's ID and name along with the order ID of orders placed by the customer. List the results by customer name and then order id. Show only customers who made an order.

Hint: use inner join operation

3.1 Show all customers including customers who did not place any orders.

Hint: use outer join operation

4. Get the customer's ID and name of customers who has ordered any desk products.

Hint: use join operation to combine customer_t , order_t, order_line_t and product_t;

use wildcard notations to find the products whose product_description contain the "desk" word.

 

5. Get the ID and name of customers who have made more than two orders.

Hint: use join operation to combine customer_t and order_t;

use count function to calculate the number of orders made by each customers and use the having clause to write the conditions.

CUSTOMER Customer ID Customer_Name Customer_Address Customer_City Customer_State Postal Code EMPLOYEE Employee ID Employee Name Employee Address Employee_City Employee State Date Hired -1 ORDER Order ID Order Date Customer ID Employe_ID Order_line Order ID Product ID Ordered Quantity 00 PRODUCT Product ID Product Name Product Finish Product Price Product Line ID