http://yunus.hacettepe.edu.tr/~tonta/courses/spring2000/dok322/northwind-queries.htm/
NORTHWIND QUERIES
Note: Please use the Northwind database
to answer the following questions. The
database can be found under MS Access subdirectories in the lab computers. The
assignment is due by March 31, 2000 09:000. Please turn in your answers
on a floppy diskette.
1.
Find the names of all “sales representatives” who work in the USA.
2.
Find the names and addresses of all the suppliers which can provide
“tofu”. (Note: You should be
able to find two companies.)
3.
Calculate the total sales for orders shipped to the United Kingdom.
4.
Find the products on order from companies in France.
5.
List all the orders taken by the employer Steven Buchanan.
6.
List all the orders taken by the employer Steven Buchanan from the
companies based in London along with the unit price and quantity of each order.