Question

Modify the SQL query to display only medical insurance plans. Add criteria to the InsuranceType field to return only records where the classification is Medical. Run the query.

a. Type "Medical" in the Criteria row in the InsuranceType column. On the Query Tools Design tab, in the Results group, click the Run button.
b. Enter "Health" in the Criteria row in the InsuranceType column. On the Query Tools Design tab, in the Results group, click the Run button.
c. Set "InsuranceType" to "Medicare" in the Criteria row. On the Query Tools Design tab, in the Results group, click the Execute button.
d. Specify "Coverage: Medical" in the Criteria row for the InsuranceType column. On the Query Tools Design tab, in the Results group, click the Execute button.

Answer 1

The SQL query to display only medical insurance plans is to type "Medical" in the Criteria row in the InsuranceType column and run the query.

Step-by-step explanation:

The correct SQL query to display only medical insurance plans is option a. Type "Medical" in the Criteria row in the InsuranceType column. On the Query Tools Design tab, in the Results group, click the Run button. This will filter the records where the classification is Medical.