select department.name from client, assignment, employee, department where client.name='Telco Inc' and client.clientID = assignment.clientID and assignment.employeeID = employee.employeeID and employee.departmentID = department.departmentID;
Use BENCHMARK to time this query over a large number of executions, and use EXPLAIN to see how it is executed. See whether you can increase the speed of execution by adding an index and rebenchmarking.
