1. Write a query that provides a count of the products sold without duplicate products counted, the territory in which the products were sold and limit the results for those sold to territories 4 and 6 and the total sum of products by ProductID.
2. Write a query that returns the full name of the customer, a count of the number of customers that ordered a product and gives a sum of the products ordered by those customers as long as the sum is at least $1000.