The tblInventory table contains a numeric field named InStock. Which of the following statements calculates the total of the items in inventory?

a. Dim intTotal As Integer =

Aggregate item In InventoryDataSet.tblInventory

Select item.InStock

Into Sum

b. Dim intTotal As Integer =

Sum item In InventoryDataSet.tblInventory

Select item.InStock

Into Total

c. Dim intTotal As Integer =

Aggregate InventoryDataSet.tblInventory.item

Select item.InStock

Into Sum

d. Dim intTotal As Integer =

Sum item In InventoryDataSet.tblInventory.InStock