Question
MPROPERTY (Property_ID, Owner_ID, Owner_Name, Owner_email, Owner_type) Where Property_ID is the id of property owned by an owner (assume one property can be owned by one
MPROPERTY (Property_ID, Owner_ID, Owner_Name, Owner_email, Owner_type) Where Property_ID is the id of property owned by an owner (assume one property can be owned by one owner only) Owner_ID is the ID of Owner Owner_name is name of the owner Owner_email is the e-mail of the owner Owner_type is type of owner (individual, corporate or Partnership) MEMPLOYEE (Employee_ID, Last_name, First_Name, CellPhone, ExperienceLevel) Where EMPLOYEE_ID is the ID of employee Last_name is last name of the employee First_name is the first name of employee CellPhone is cell number of employee ExperienceLevel is based on number of years of experience and is classified as Master, Junior or Senior MSERVICE (Property_ID, Employee_ID, Service_Date, Hours_worked) Where Service_date is the date that property was serviced Hours_worked is the number of hours that employee worked on that project Write following queries in SQL for q1-q15 6. Give employee_id of employees not servicing any properties 7. Give the name of owner who employs employee whose last name is CORY. 8. Give the maximum, average and minimum working hours of each employee 9. Give name of employees who work for more than 2 properties
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started