What set operator would you use if you wanted to see all of the customers and the employees including any records that may appear in both customers and employees? select firstname ,lastname ,phone from customers select firstname ,lastname ,phone from employees; group of answer choices1 intersect2 except3 union all4 union

1. INTERSECT

Explanation:

Intersection is the set operator that gives us the information which is common to both tables. In this case the query will be:

SELECT firstname, lastname, phone FROM Customers

INTERSECT

SELECT firstname, lastname, phone FROM Employees;

storage maybe?

are there options?

solution:

the right option is a

to adding   a new row to a table we   have to do process last table cell and pressing tab.

this is the process to add new row in the cell:

* to add a row below the cell, click insert below in the rows and columns group.

thus this is the required right answer.