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 printout of SQL statements....
View Full
Document
 Spring '08
 Chen,Z

Click to edit the document details