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 . . . .

June 27, 2024June 27, 2024| adminadmin| 0 Comment| 8:33 pm
Categories:

 

  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

(Solved) : 1 Refer Table 10 Using Select Statement Would Possible Output Select Name Org Position Org Q29918893 . . . .(Solved) : 1 Refer Table 10 Using Select Statement Would Possible Output Select Name Org Position Org Q29918893 . . . .

<p><img alt="TABLE 1.0 ORGCHART ORG POSITION ID NAME 10 REYES, ANNA AMATHS PRES 15 AGAPITO, JUN SCSEC CRUZ, JOAN PCS MEMBER 12 DUQUE,ROAN JPCS 21 LASON,MOJICA MEMBER" src="https://media.cheggcdn.com/media%2F276%2F276ae513-5b6f-48f5-829c-1d131e509740%2FphpQWWMi7.png" style="height:372px;width:704px;" aria-describedby="d3f"/></p><p>1.</p><p>Refer

Read MoreRead More