I will provide you with a Access DB and the following information must be extrated or completed via SQL. This must be done in the most simple form without any bells or whistles. Just simply provide the bare bones of what is required. The following is what is required from the DB: Using SQL, add 10 more employees to the employee table. Make sure foreign keys are correct in the Employee table. Write a SQL query that shows the number of Territories that each employeeId has. Sort by EmployeeId Write a SQL query that shows the number of orders that are for products that have a UnitPrice > $30 and the Supplier Country is USA
All SQL code must be completely error free and be able to run in Access 2000. It must work explicitly according to the directions.
Windows 98 Access 2000