The tblMagInfo table contains three fields. The Code and Cost fields are numeric. The Magazine field contains text. The dataset's name is MagsDataSet.
1. Write a LINQ statement that arranges the records in descending order by the Cost field.
2. Write a LINQ statement that selects records having a code of 9.
3. Write a LINQ statement that selects records having a cost of $3 or more.
4. Write a LINQ statement that selects the Daily Food Guide magazine.
5. Write a LINQ statement that selects magazines whose name begins with the letter G (in either uppercase or lowercase).
6. Write a LINQ statement that calculates the average cost of a magazine.