Will rate

2. [80 points] Consider the employee database of Fig. 1, where the primary keys are underlined. Write an SQL query to find, for every state, the number of families in every city with family incomes higher than the average family income of the state. Assume that the family income of a family is the sum of salaries of employees living al the same address. Note that you shall generate a relation higherThanAverage Families(count, city, state). employee(employee-id, employee-name, street-number, street, city, state) works(employee-id, company-id, salary Figure 1. Employee database