Question

Write a query to display customer name, orderID, and productID for the orders that have more than one product.

Answer 1

The query that displays the required data is

SELECT name, orderID, productID FROM Products WHERE Product > 1

How to rewrite the query?

To do this, we make use of the following parameters:

• Table name: Products
• Columns to read: name, orderID and productID
• Condition: Product > 1

Next, we make use of the SELECT query

The syntax of the SELECT query is:

SELECT columns from table where condition

So, we have:

SELECT

name, orderID, productID

FROM Products

WHERE Product > 1

Read more about SQL query at:

brainly.com/question/19801436

#SPJ1