The Magazine table contains three fields. The Cost field is numeric. The Code and Name 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 Name and Cost fields from records having a code of PG10.
c. Write a SQL SELECT statement that selects only the Name 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 Name field from records whose magazine name begins with the letter C.
f. Write a SQL SELECT statement that selects only the Name field from records whose magazine name contains two characters.
g. Write a SQL SELECT statement that selects only the Name and Cost fields from records whose cost is from $4 to $6, inclusive.
h. Write a SQL SELECT statement that selects only records for the Code provided by the user.
i. Write a SQL SELECT statement that selects only records that cost at least as much as the amount provided by the user.
j. Write a SQL SELECT statement that selects only records that cost more than the first amount provided by the user but less than the second amount he or she provides.
k. Open the Harken Solution.sln file contained in the VB2017\Chap12\Harken Solution folder. The application is already connected to the Harken.mdf database, and the HarkenDataSet has already been created. 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 j.