I'm intrigued with Jeff's approach to #3, using COUNT(DISTINCT Order_ID+Product_Type). After reading the initial post, I wrote this:

SELECT COUNT(Distinct oe.Order_ID) FROM Orders oe

INNER JOIN Orders...