SQL Sample question

1.       Find out Name of customer who has maximum number of product?

2.       Find out Name of customer who does not have product.

/*find customer who has maximum product*/

select top 1 c.Name , COUNT(c.ID) as CustomerCount from Customer c left outer join CustomerProduct cp

      on c.ID = cp.CustomerID

            group by c.ID ,c.Name

            order by CustomerCount desc

/*find all customers who does not have any product*/

select c.Name  from Customer c left outer join CustomerProduct cp

      on c.ID = cp.CustomerID

     

            where cp.CustomerID is null