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 names begin with the letter C.

f. Open the Magazine Solution (Magazine Solution.sln) file contained in the VB2012\Chap14\Magazine Solution-SQL folder. If necessary, open the designer window. 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.

g. Close the Query Builder dialog box and the TableAdapter Query Configuration Wizard dialog box. Save the solution. Close the MagazinesDataSet.xsd window and then close the solution.