Question: The tblBooks table in the Books database contains a numeric field named Price. Which of the following determines the number of books whose price is

The tblBooks table in the Books database contains a numeric field named Price. Which of the following determines the number of books whose price is at least $20? The dataset’s name is BooksDataSet.

a. Dim intNum As Integer =

Aggregate book In BooksDataSet.tblBooks
Where book.Price > 20
Into Count

b. Dim intNum As Integer =

Aggregate book In BooksDataSet.tblBooks
Where book.Price >= 20
Into Sum

c. Dim intNum As Integer =

Aggregate book In BooksDataSet.tblBooks
Where book.Price >= 20
Select book

d. Dim intNum As Integer =

Aggregate book In BooksDataSet.tblBooks
Where book.Price >= 20
Into Count

Step by Step Solution

3.38 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

d Dim intNum As In... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming with Microsoft Visual Basic 2015 Questions!