You use a Microsoft SQL Server database that contains a table. The table has records of web requests as shown in the exhibit. (Click the Exhibit button.)
Your network has three web servers that have the following IP addresses:
• 10.0.0.1
• 10.0.0.2
• 10.0.0.3
You need to create a query that displays the following information:
The number of requests for each web page (UriStem) grouped by the web server (ServerIP) that served the request A column for each server Which Transact-SQL query should you use?
A.
B.
C.
D.