Big Store

CLICK HERE TO DOWNLOAD THIS TUTORIAL INSTANTLY $25  Only

For this week assignment you will use this database to answer the following queries in SQL:
1. Find the street and city of all employees who work for the “BigStore”, live in “New York”, and earn more than $35,000.

2. Find the names and the companies they work for, for all people who have a higher salary than their manager.

3.  Assume that companies may be located in several cities. Find all companies located in every city in which the “BigStore” is located.

4. Find the names of managers who manage more than 5 employees living in “Richmond”.
Copy and paste the code from SQL Server to Notepad document and submit it via e-mail.