Unformatted text preview: points] Problem 2: Find all employees who earn less than the average salary of all employees of their company. [30 points] Hint: use subquery to compute average salary of the company an employee is working at. Group by is not needed. Problem 3: List the names of companies and the number of employees in each company. [20 points]. Problem 4: Find all cities with at least two companies. [30 points] Please submit print-out of SQL statements....
View Full Document
- Spring '08
- SQL statements, 5%, Bank Corporation, First Bank Corporation, average salary