Answered You can hire a professional tutor to get the answer.

QUESTION

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET

Using the Company schema, list every project name and average employee salary for employees in the project.

Use explicit joins.

Note that the avg salary for project 61 (OperatingSystems) is 42,166.

Expected Result Set Size: 11 i.e. the number of projects.

The company schema is attached that can be used with MySQL workbench or whatever preferred program

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question