Question: I have created and insert queries : Table 1: Employee Employee_name Street City William Gates III University St Redmond Warren Buffett Alaskan Way Omaha Table
I have created and insert queries :
Table 1: Employee
| Employee_name | Street | City |
| William Gates III | University St | Redmond |
| Warren Buffett | Alaskan Way | Omaha |
Table 2: Works
| Employee_name | Company_name | Salary |
| William Gates III | Microsoft | 1400000 |
| Warren Buffett | Exxon Mobil | 230000 |
Table 3: Company
| Company_name | City |
| Microsoft | Redmond |
| Exxon Mobil | Omaha |
Table 4: Manages
| Employee_name | Manager_name |
| Paul Allen | William Gates III |
| Carlos Slim Helu | Lakshmi Mittal |
I have created and insert queries :
Questions:
1- Find the names of all employees who do not work for either Microsoft or Facebook.
2- Find cities of residence of all employees who earn either strictly less than $50,000 or strictly more
than $400,000.
3- Find the company name and their number of employees. Display the results in descending order or
the number of employees. If two companies have the same number of employees, display them in
lexicographical order.
4- Find the name of managers that have their salary smaller than some of the employee they manage.
thank you..
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
