- Employee Employeel Lastme Firstname Cellphone Experiencelevel 1 Smith Sam 206 254 1234 Master Evanston John 206 254 2345 1 (132.39 KiB) Viewed 16 times
and First Name, and sum of Hours Worked for each employee ordered
by the employee Last Name
2. Write a SQL statement to show information about
the most expensive service
3. Write an SQL statement to list the Names of
employees who have Worked on a Property Owned by a Corporation
4. Write an SQL statement to show all properties
and the services performed at those properties. The output
from this statement should include any properties that have not had
any service performed at them. The SQL statement output
should list PropertyID, PropertyType, PropertyName,
PropertyServiceID, ServiceID, ServiceDate, and
ServiceDescription.
EMPLOYEE Employeel Lastme FirstName Cellphone ExperienceLevel 1 Smith Sam 206-254-1234 Master Evanston John 206-254-2345 Senior Murray Dale 425-545-7654 unior Murphy Jerry 425-545-8765 Master Fontaine on 206-254-3456 Senior OWNER Owner Owner Name Owner mal Owner Type 1 Mary Jones Mary Jonesomewhere.com Individual 2 DT Enterprises DTEdte.com Corporation 3 Sam Douglas Som Douglas somewhere.com Individual UNY Enterprises UNYE Dunye.com Corporation 5 Doug Samuels Doug Samuels somewhere.com individual 25.00 GG_SERVICE Service Service Description Courtour Mow Lawn Plant Avuls 25.00 3 Weed Garden 30.00 Trim Hedge 45.00 5 Prune Small Tree 60.00 Trim Medlun Tree 100.00 7 Trim Large Tree 125.00 OWNED_PROPERTY Property Propertyflame Property Type Street State ZP Owner ID 1 Eastike Building Office 123 Eastlake Seattle WA 981192 2 Elm St Apts Apartments East Elm Lynwood WA 982231 Jefferson Office 42 West 7th St Bellevue WA 980072 Lake View Apts Apartments 1265 32nd Avenue Redmond WA 980523 5 Kodak Heights Apts Apartments 65 32nd Avenue Redmond WA 980524 6 Jones House Private Residence 3456 48th St Bellevue WA 98007 1 7 Douglas House Private Residence 1567 51st St Bellevue WA 980073 Samuels House Private Residence 567 15 ist St Redmond WA 900525 PROPERTY_SERVICE Property Service Property Service ServiceDate Employeel HoursWorked 1 2 2014-05-05 1 4.50 3 2 2014-05-08 3 4.50 2 1 2014-05-08 2 2.75 6 1 2014-05-10 5 2.50 5 4 2014-05-12 4 7.50 1 2014-05-15 4 2.75 4 4 2014-05-19 1 1.00 1 2014-05-21 2 2.50 6 3 2014-06-03 5 2.50 10 5 7 2014-06-08 10.50 11 8 3 2014-06-12 4 2.75 12 4 5 2014-06-15 1 5.00 13 3 2014-06-19 2 4.00 4