Question
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
