The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.

a.Dim records =

From customer In CustomerDataSet.tblCustomer

Where customer.InvoiceAmt > 200

Order invoice.CustomerNum Ascending

Select customer

b.Dim records =

From CustomerDataSet.tblCustomer

Where customer.InvoiceAmt > 200

Order invoice.CustomerNum

Select customer

c.Dim records =

From customer In CustomerDataSet.tblCustomer

Where customer.InvoiceAmt > 200

Order By invoice.CustomerNum

Select customer

d.Dim records =

From customer In CustomerDataSet.tblCustomer

Where customer.InvoiceAmt < 200

Order By invoice.CustomerNum

Select customer