Edit select queries for Coast Jewelers. a. Edit Query 1 by adding the field Postal Code and

Question:

Edit select queries for Coast Jewelers.
a. Edit Query 1 by adding the field Postal Code and deleting the field Stateor Province. Save this query as Ch 11 Assignment 3a before you print it.
b. Edit Query2 to include the field Category Name and to include only the category Rings, sorted by product name in ascending order. Save this query as Ch 11 Assignment 3b before you print it.