h. There are movies with more than a dozen actors i. Some producers have been a
ID: 3834370 • Letter: H
Question
h. There are movies with more than a dozen actors i. Some producers have been a director as well. j. Most movies have one director and one producer k. There are some actors, who have had a lead role, directed a movie, and produced some movie I. No movie has a director who also acted in that movie. m. Some movies have one director but several producers. Exercise 2 Garden Glory is a partnership that provides gardening and yard maintenance services to individual and organizations. Assume that Garden Glory designs a database with the following tables: OWNER Name, Email, Type) PROPERTY(Property ID, Street, City. State, Zip, ownerlD) EMPLOYEE (nitials, Name, Cell Phone, ExperienceLevel) SERVIC PropertID Initials, Date, HoursWorked) Type is either Individual or Corporation, a ExperienceLevel is one of Junior, senior, Master or SuperMaster. Code SQL statements to answer the questions below: 1. List all columns of all tables 2. List the Name and CellPhone of all employees having an experience level of Master. 3. List the Name and CellPhone of all employees having a Name that begins with J. 4. List the Name of employees who have worked on a property in New York (use subquery) 5. Same as d,but using a join 6. Show the number of properties of Type Corporation. 7. List the Name of employees who have worked on a property owned by a CorporationExplanation / Answer
1. Select * FROM OWNER;
Select * FROM PROPERTY;
Select * FROM EMPLOYEE;
Select * FROM SERVICE;
2. Select Name,CellPhone from EMPLOYEE Where ExperienceLevel='Master';
3. Select Name,CellPhone from EMPLOYEE WHERE Name like 'j%';
4. Select Name FROM EMPLOYEE
5.
6. select sum(PropertyID) from PROPERTY P INNER JOIN OWNER O
ON P.OWNERID=O.OWNERID AND O.TYPE='CORPORATION';
7.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.