Course Solutions Uncategorized (Solved) : 2 Find Name Product Ordered Order Date Products Ordered Customer Customer Code Savea Quant Q38039315 . . . .

(Solved) : 2 Find Name Product Ordered Order Date Products Ordered Customer Customer Code Savea Quant Q38039315 . . . .

 

  1. (2) Find a name of product ordered and order date of allproducts ordered by a customer with customer code SAVEA and suchthat quantity of product is 10.

  2. (3) Find the total number of cities the customers who submittedat least one order in1996 or in 1997 or in 1998 come from.

  3. (4) Find a description of category such that at least oneproduct from the category has unit price greater than 100.

  4. (5) Find the names of products that have not been ordered yet. Ahint is to use OUTER JOIN operation.

  5. (6) Find the first and last name of a direct manager of employeewhose first name

    OR

    PayPal Gateway not configured

    OR

    PayPal Gateway not configured

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post