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

5. 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

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!