What sort of information has the query selected:
All the products with a unit price of $10
Enter another value in the criteria row of the cost column.
I entered 15
What sort of information has this second query selected?
All the products with a unit price of $15
Design the following queries and describe the type of information they are selecting.

This query allows us to look at all products and their unit prices that have a reorder level of 10. (as you can see from below)

< this query enables us to look at products and their reorder levels with the units in stock ascending (as you can see below:)
No comments:
Post a Comment