Follow these directions to export the Northwinds database to MariaDB (or MySQL).
Use the database to answer these queries:
- Get supplier names and order ID for all orders.
- Get supplier name, order ID and product name for all orders supplied by "Tokyo Traders."
- Get supplier name, order ID, product name, and dollar value of the amount of that product ordered for each order supplied by "Tokyo Traders."
- Get the shipper name and supplier name for all orders shipped by "Speedy Express."
- List the shipper name and the number of orders shipped by each shipper.
- Display the quantity ordered of each product.
- Write a query that shows how many orders are associated with each customer ID. Note that the customerID field is replaced with the Customer’s name. Why is that?
- Total inventory (dollar value) on hand by category.
- Show the company names of all customers that have ordered the product "Aniseed Syrup."
- Show the company names of all suppliers who have discontinued products.
- Show the total dollar value of all the orders we have for each customer (one dollar amount for each customer). Order the list in descending order.
- Show all products that have UnitsInStock that are below the ReorderLevel.
- What are the last names of all employees born before Jan 1, 1960?
- List the supplier name and city for all suppliers based in the United States.
- List the supplier name and URL for all suppliers that have a home page.
- Using one of the special operators, list the supplier name and country for all suppliers based in an English-speaking county.
- Using one of the special operators, list the product name and price for all products that sell for as little as $10 and as much as $20.
- List the company name for all customers whose company name falls between 'L' and 'O', inclusive.
- List the last name and title for all employees who work in sales.