Question: Open the PremiumCriteriaQuery in SQL View. Add a WHERE clause to the query in the position shown in Figure 4 that restricts retrieval to only
Open the PremiumCriteriaQuery in SQL View. Add a WHERE clause to the query in the position shown in Figure that restricts retrieval to only those policies where the premium is greater than Hint: Figure demonstrates the proper location for the WHERE clause, but it does not show the criteria that should be included in the WHERE clause. Run the query, and check your results to confirm that eight records meet the criteria. Save and close the PremiumCritieraQuery.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
