which sql query/queries would be used to answer the following business question: show the customer id, customer firstname, and customer lastname for customers that have placed at least one order. also, show the orderdate and orderid associated with each order.
Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?
a. UNION c. INTERSECT
b. UNION ALL d. MINUS