The underlined attribute(s) are the primary key

Using the following tables create SQL queries:

1. Find the company name and their number of employees. Display the results in descending order or the number of employees. If two companies have the same number of employees, display them in lexicographical order.

2. Find the name of managers that have their salary smaller than some of the employee they manage.

Table 1: Employee Employee name Street City Table 2: Works Employee name Company name Salary Table 3: Company Company name City Table 4: Manages Employee_name Manager_name