Wednesday, February 15, 2012

Querying A Database

Question 1:
Suppliers-We need a Query with a contact name, the phone number of all companies in the USA. Below is the Query.
Below is the Result of the Query.


Question 2: Product Names that cost more than $20
Here is the Query

 Here are the Results:

Question3:Products with more than 30 items in stock
Here is the Query:
 Here are the Results:


No comments:

Post a Comment