Free Download New Updated Microsoft 70-433 Real Exam Questions and Answers 51-60

EnsurepassQUESTION 51 You have a table named Sales. You are tasked to list products that have been sold to less than ten customers. You need to write a query to achieve the task. Which Transact-SQL statement should you use?   A. SELECT ProductID, COUNT(*) AS CustomerCount FROM Sales GROUP BY ProductID, CustomerID HAVING COUNT(*) < 10; B. SELECT ProductID, COUNT(DISTINCT CustomerID) AS CustomerCount FROM Sales GROUP BY ProductID HAVING COUNT(DISTINCT CustomerID) < 10; C. SELECT Read more […]

Continue reading