1 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

Question

1  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

SolutionInn · Accepted Answer

Lets go through each part of the question and write the SQL SELECT statements as requested a SQL SELECT statement for arranging records in descending ...

Question: 1. The tblMagazine table contains three fields. The Cost field is numeric. The Code and MagName fields contain text. a. Write a SQL SELECT statement

Step by Step Solution