Wednesday, February 15, 2012

Querying A Database

Yesterday we created queries for a database. We asked different queries to find out different information about the same products.

Query 1:
Product name of compaines in the USA

Results for Query 1:


Query 2:
Product name and Price over $20


Results for Query 2: 



Query 3:
Procduct name and the amoun of stock then have is over 30

Results for Query 3: