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 );
