The underlined attribute(s) are the primary key

Using the following tables create SQL queries:

1. Find the name of the managers and the average salary of the employees they manage.

2. Find all managers that manage employees with at least 3 letters 'a' or 'e' in their name (both uppercase and lowercase). For instance having 2 'a' and 1 'e' in the name, will satisfy the selection criteria.

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