The tblMagazine table contains three fields. The Cost field is numeric. The Code and MagName fields contain text.

a. Write a SQL SELECT statement that arranges the records in descending order by the Cost field.

b. Write a SQL SELECT statement that selects only the MagName and Cost fields from records having a code of PG10.

c. Write a SQL SELECT statement that selects only the MagName and Cost fields from records having a cost of $3 or more.

d. Write a SQL SELECT statement that selects the Visual Basic record.

e. Write a SQL SELECT statement that selects only the MagName field from records whose magazine name begins with the letter C.

f. Open the VB2015\Chap14\Magazine Solution\Magazine Solution (Magazine Solution.sln) file. The application is connected to the Magazines database. Start the application to view the records contained in the dataset, and then stop the application. Open the DataSet Designer window and then start the TableAdapter Query Configuration Wizard. Open the Query Builder dialog box. Use the dialog box to test your SELECT statements from Steps a through e.