Question: Specify the following SQL queries on the Company database as discussed in class 1 . Retrieve the average salary of all employees who works on

Specify the following SQL queries on the Company database as discussed in class 1.Retrieve the average salary of all employees who works on ProductX project 2.For each employee with dependents, list employees name, and the number of dependents who depend on the employee. 3.Retrieve the names of employees who work on every project controlled by department 44.For each employee, retrieve employees name, and the total hours working in projects 5.List the last names of male employees who have no dependents. Part 2: Specify the following SQL queries on the University database as discussed in class 6.Retrieve the names of all courses taught by Professor Satish 7.For each section taught by Professor Satish, retrieve the number of students who took the section 8.Retrieve the names of students who have never received any F grade 9.Retrieve names of students who took Calculus I with Professor Satish give the quarries

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!