I need help writing the following statements on MYSQL Write

I need help writing the following statements on MYSQL: Write and execute a SELECT statement that returns the name of the company from the Companies table that has the most number of employees. Write and execute a SELECT statement that returns the name of the company from the Companies table that has the least number of employees.

Solution

SELECT company_name from COMPANIES,EMPLOYEE where count(emp)<(SELECT count(emp) from COMPANIES C,EMPLOYEE E where C.company_name=E.company_name );

I need help writing the following statements on MYSQL: Write and execute a SELECT statement that returns the name of the company from the Companies table that h

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site