Question: Use Microsoft Access to find and install the Northwind Database with all the information. Convert the database into a SQL document Import all the information
Use Microsoft Access to find and install the Northwind Database with all the information.
Convert the database into a SQL document
Import all the information into MySQL
Start a tee file and:
Run a query on all the items in the inventory
Run a query to find all the sales representatives
Run a query that show items with available inventory above 50
Run a query that show items with available inventory below 0
Run a query on which employees placed orders for Company C
Run a query on amount of all items and the amount sold.
***Bonus*** Run a query on company that sales were between 2000 and 5000, (Requires multiple tables and calculations)
Submit tee file.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
