This preview shows page 1. Sign up to view the full content.
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