microsoft worksheet

profileblueamber95
Christopher.Wagoner-AC2016-ChallengeYourself-2-3.accdb
Home>Computer Science homework help>microsoft worksheet
EmployeeID FirstName LastName Position WeeklyHours
11782741 Gary Miller Greenhouse Tech 2 20
23605379 Jasmin Singleton Greenhouse Tech 2 20
31269314 Paola Rojas Greenhouse Tech 1 30
59267312 Tracy Morber Greenhouse Tech 2 20
68023812 Dale Barnes Greenhouse Tech 1 35
77813350 George Russell Greenhouse Tech 2 15
MaintenanceID MaintenanceDate EmployeeID PlantID Watered Inspected Pruned
1 9/15/16 11782741 ALFA2 No Yes
2 9/18/16 31269314 ASTU Yes Yes Yes
PlantID CommonName ScientificName FlowerColor DatePlanted MaxHeightFeet PurchasePrice
AGPU5 Gerardia Agalinis purpurea Violet 4/11/13 6.0 ¤ 4.50
ALFA2 White colicroot Aletris farinosa White 4/9/14 3.5 ¤ 7.50
AMTA2 Eastern bluestar Amsonia tabernaemontana Blue 5/1/09 3.0 ¤ 7.50
ANBE Wind-flower Anemone berlandieri Violet 4/11/13 1.0 ¤ 4.00
AQCA Eastern red columbine Aquilegia canadensis Red 3/29/10 2.0 ¤ 8.25
ASTU Butterflyweed Asclepias tuberosa Orange 3/31/12 2.0 ¤ 11.50
BAAL White wild indigo Baptisia alba White 4/15/04 4.0 ¤ 6.25
BAAU Blue wild indigo Baptisia australis Blue 5/6/15 4.0 ¤ 6.25
COER Widow's tears Commelina erecta Blue 5/6/15 3.0 ¤ 4.95
COGL2 Coastal tickseed Coreopsis gladiata Yellow 4/21/13 5.0 ¤ 3.15
COLA5 Lanceleaf tickseed Coreopsis lanceolata Yellow 5/12/13 2.5 ¤ 5.25
CONU5 Georgia tickseed Coreopsis nudata Pink 3/31/12 5.0 ¤ 3.15
GAPU Firewheel Gaillardia pulchella Red 3/31/12 2.0 ¤ 5.50
GEMA Spotted geranium Geranium maculatum Violet 9/15/12 3.0 ¤ 4.50
HEDE4 Beach sunflower Helianthus debilis Yellow 4/19/13 6.0 ¤ 3.50
IPRU2 Standing cypress Ipomopsis rubra Red 4/21/13 4.0 ¤ 6.50
KOVI Seashore mallow Kosteletzkya virginica White 4/30/16 5.0 ¤ 8.25
LOCA2 Cardinal flower Lobelia cardinalis Red 4/30/16 6.0 ¤ 9.50
LUPE3 Wild lupine Lupinus perennis Blue 4/30/16 2.0 ¤ 5.85
MOFI Wild bergamot Monarda fistulosa Pink 4/30/16 5.0 ¤ 3.50
MOPU Horsemint Monarda punctata White 4/21/13 3.0 ¤ 4.90
PECO4 Wild foxglove Penstemon cobaea White 5/12/13 2.0 ¤ 2.90
PHNI Trailing phlox Phlox nivalis Pink 3/30/06 1.5 ¤ 2.50
RHAL4 Savannah meadowbeauty Rhexia alifanus Pink 3/31/12 2.0 ¤ 1.90
RHCA7 Wild azalea Rhododendron canescens White 4/11/13 8.0 ¤ 10.50
RHVI Handsome Harry Rhexia virginica Pink 4/9/14 3.0 ¤ 6.80
RUHI2 Black-eyed Susan Rudbeckia hirta Yellow 4/21/13 2.0 ¤ 3.15
SACO5 Scarlet sage Salvia coccinea Red 4/9/14 3.0 ¤ 8.20
YUFI Adam's needle Yucca filamentosa White 5/6/15 6.0 ¤ 10.90
SELECT DISTINCTROW * FROM Employees;
SELECT DISTINCTROW * FROM Employees;