Categories

Customers

Employees

Order Details

OrdersProducts

Shippers

Suppliers

1. A query list any product that is of unit price below $20. Show product name, supplier, and unit price.

2. A query list all suppliers that the fax number is missing.

3. A query list all cities in France and the count of orders placed with them.

4. A query list all customers and the total and average freight for each of them based on the order records

Category IICategory Name Description Picture Beverages 2 Condiments 3 Confections 4 Dairy Products 5 Grains/Cereals 6 Meat/Poultry 7 Produce 8 Seafood Soft drinks, coffees, teas, beers, and ales Sweet and savory sauces, relishes, spreads, and seasonings Desserts, candies, and sweet breads Cheeses Breads, crackers, pasta, and cereal Prepared meats Dried fruit and bean curd Se Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image aweed and fish Category IICategory Name Description Picture Beverages 2 Condiments 3 Confections 4 Dairy Products 5 Grains/Cereals 6 Meat/Poultry 7 Produce 8 Seafood Soft drinks, coffees, teas, beers, and ales Sweet and savory sauces, relishes, spreads, and seasonings Desserts, candies, and sweet breads Cheeses Breads, crackers, pasta, and cereal Prepared meats Dried fruit and bean curd Se Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image Bitmap Image aweed and fish