1. The tblBooks table contains five fields. The BookNum, Price, and QuantityInStock fields are numeric; the Title and Author fields contain text. The dataset’s name is BooksDataSet.

a. Write a LINQ statement that arranges the records in ascending order by the Author field.

b. Write a LINQ statement that selects records having a price of at least $12.75.

c. Write a LINQ statement that selects records having more than 100 books in inventory.

d. Write a LINQ statement that selects the books written by George Marten and arranges the books in descending order by the book’s price.