Question: The underlined attribute(s) are the primary key Using the following tables create SQL queries: 1….

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

Scroll to top
AllEscortAllEscort