Problem
Create a query that lists all the customer numbers from the customers table in Ascending order.
Note the values of the first 10 customers .Now use the INTERSECT set operator to show all customers who have placed an order. Just display the customernumber in Ascending order.
Take note of the first 10 customer numbers. Take note of how many customers have placed an order.
Now use the MINUS set operator to show all customers who have NOT placed an order. Just display the customernumber in Ascending order.
Take note of the first 10 customer numbers. Take note of how many customers have placed an order.
Using your query from question 3 (MINUS set operator) display the customer numbers and the names of the customers who have never placed an order and show it in ascending order by customernumber.