Question: employees( eid , ename, age, salary, address, years_of_experience, dname) departments( dname , location, manager_id, budget) projects( pname , location, start_date) works_on( eid, pname , hours)
employees(eid, ename, age, salary, address, years_of_experience, dname)
departments(dname, location, manager_id, budget)
projects(pname, location, start_date)
works_on(eid, pname, hours)
List the name of departments that have managers that make less than $75,000 and that have employees making more than $100,000
List the salary of the employees from the systems department that works on every project located in Madison (works on all projects)
List the name of the department on which all employees work on a project that started before 11-26-2020
List the ids and names of employees that work in a department located in Phoenix who have the same years of experience as their own manager
List the name of employees with less than five years of experience working on both a project located in Tucson and in a project located in San Francisco.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
