7. Find Employees in Period - [несъответствие на отговор-а с условието]
Здравейте,
В условието на задача: 7. Find Employees in Period (Find the first 30 employees who have projects started in the time period 2001 - 2003 (inclusive).) и резултатите, които джъдж-а приема има някъкво несъответствие. Неразбиране на условието или неправилен тест е причината?
P.S. (не намерих друг начин за репорт на проблеми с задача в judje)
Guy Gilbert Jo
--Half-Finger Gloves 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Racing Socks 11/22/2005 12:00:00 AM
--Women's Tights 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Road Bottle Cage 2/21/2004 12:00:00 AM
Roberto Tamburello Terri
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--HL Road Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Rob Walters Roberto
--Road-150 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Pedal 5/16/2005 4:34:00 PM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Thierry D'Hers Ovidiu
--Road-350-W 6/1/2003 12:00:00 AM
--Road-350 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Mountain Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
JoLynn Dobney Peter
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Ruth Ellerbrock Andrew
--Cycling Cap 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400-W 2/22/2006 12:00:00 AM
--Touring-3000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Water Bottle 6/1/2003 12:00:00 AM
Gail Erickson Roberto
--LL Road Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Hitch Rack - 4-Bike 6/1/2003 12:00:00 AM
Barry Johnson Andrew
--Full-Finger Gloves 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-500 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Women's Mountain Shorts 6/1/2003 12:00:00 AM
--Mountain Bottle Cage 6/1/2003 12:00:00 AM
Jossef Goldberg Roberto
--LL Touring Frame 5/16/2005 4:34:00 PM
--Touring Pedal 5/16/2005 4:34:00 PM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Bike Wash 8/1/2005 12:00:00 AM
Terri Duffy Ken
--Road-450 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Front Wheel 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--LL Road Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Sidney Higa Andrew
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Touring Handlebars 5/16/2005 4:34:00 PM
--Rear Derailleur 6/1/2003 12:00:00 AM
Taylor Maxwell Peter
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Jeffrey Ford Andrew
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-2000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Jo Brown Peter
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Dual-Beam 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Rear Derailleur 6/1/2003 12:00:00 AM
Doris Hartwig Andrew
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Dual-Beam 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Rear Derailleur 6/1/2003 12:00:00 AM
John Campbell Peter
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-2000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Diane Glimp Andrew
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Steven Selikoff Michael
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Peter Krebs James
--LL Touring Frame 5/16/2005 4:34:00 PM
--Road-650 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Bike Wash 8/1/2005 12:00:00 AM
Stuart Munson Lori
--LL Mountain Frame 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Road-450 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Front Wheel 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Mountain Pump 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Greg Alderson Lori
--LL Road Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-550-W 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Rear Wheel 5/16/2005 4:34:00 PM
--Hitch Rack - 4-Bike 6/1/2003 12:00:00 AM
David Johnson Jack
--LL Touring Frame 5/16/2005 4:34:00 PM
--Road-650 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Front Wheel 5/16/2005 4:34:00 PM
--Bike Wash 8/1/2005 12:00:00 AM
Zheng Mu Peter
--Long-Sleeve Logo Jersey 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-750 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-Panniers 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Ivo Salmre Eric
--HL Mountain Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-150 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Patch kit 6/1/2003 12:00:00 AM
Paul Komosinski David
--Road-250 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-550 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Cable Lock 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Kendall Keil Taylor
--HL Touring Frame 5/16/2005 4:34:00 PM
--Road-350-W 6/1/2003 12:00:00 AM
--Road-350 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Minipump 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Paula Barreto de Mattos Laura
--Road-250 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--HL Road Rear Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Cable Lock 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Alejandro McGuel Brenda
--Long-Sleeve Logo Jersey 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-750 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--ML Mountain Front Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-Panniers 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Garrett Young Jack
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--HL Mountain Front Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Jian Shuo Wang Cynthia
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Touring Handlebars 5/16/2005 4:34:00 PM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
--Half-Finger Gloves 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Racing Socks 11/22/2005 12:00:00 AM
--Women's Tights 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Road Bottle Cage 2/21/2004 12:00:00 AM
Roberto Tamburello Terri
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--HL Road Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Rob Walters Roberto
--Road-150 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Pedal 5/16/2005 4:34:00 PM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Thierry D'Hers Ovidiu
--Road-350-W 6/1/2003 12:00:00 AM
--Road-350 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Mountain Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
JoLynn Dobney Peter
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Ruth Ellerbrock Andrew
--Cycling Cap 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400-W 2/22/2006 12:00:00 AM
--Touring-3000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Water Bottle 6/1/2003 12:00:00 AM
Gail Erickson Roberto
--LL Road Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Hitch Rack - 4-Bike 6/1/2003 12:00:00 AM
Barry Johnson Andrew
--Full-Finger Gloves 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-500 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Women's Mountain Shorts 6/1/2003 12:00:00 AM
--Mountain Bottle Cage 6/1/2003 12:00:00 AM
Jossef Goldberg Roberto
--LL Touring Frame 5/16/2005 4:34:00 PM
--Touring Pedal 5/16/2005 4:34:00 PM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Bike Wash 8/1/2005 12:00:00 AM
Terri Duffy Ken
--Road-450 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Front Wheel 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--LL Road Handlebars 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Sidney Higa Andrew
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Touring Handlebars 5/16/2005 4:34:00 PM
--Rear Derailleur 6/1/2003 12:00:00 AM
Taylor Maxwell Peter
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Jeffrey Ford Andrew
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-2000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Jo Brown Peter
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Dual-Beam 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Rear Derailleur 6/1/2003 12:00:00 AM
Doris Hartwig Andrew
--Mountain-200 6/1/2002 12:00:00 AM 3/11/2004 10:32:00 AM
--Touring-1000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Dual-Beam 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Rear Derailleur 6/1/2003 12:00:00 AM
John Campbell Peter
--Classic Vest 6/1/2003 12:00:00 AM
--Mountain-300 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-2000 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Headlights - Weatherproof 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Diane Glimp Andrew
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--Hydration Pack 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Steven Selikoff Michael
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Taillight 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Peter Krebs James
--LL Touring Frame 5/16/2005 4:34:00 PM
--Road-650 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--ML Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Bike Wash 8/1/2005 12:00:00 AM
Stuart Munson Lori
--LL Mountain Frame 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Road-450 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Mountain Front Wheel 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Mountain Pump 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Greg Alderson Lori
--LL Road Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-550-W 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Rear Wheel 5/16/2005 4:34:00 PM
--Hitch Rack - 4-Bike 6/1/2003 12:00:00 AM
David Johnson Jack
--LL Touring Frame 5/16/2005 4:34:00 PM
--Road-650 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring Front Wheel 5/16/2005 4:34:00 PM
--Bike Wash 8/1/2005 12:00:00 AM
Zheng Mu Peter
--Long-Sleeve Logo Jersey 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-750 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--HL Fork 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-Panniers 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Ivo Salmre Eric
--HL Mountain Frame 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-150 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Mountain-400 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Patch kit 6/1/2003 12:00:00 AM
Paul Komosinski David
--Road-250 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-550 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Cable Lock 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Kendall Keil Taylor
--HL Touring Frame 5/16/2005 4:34:00 PM
--Road-350-W 6/1/2003 12:00:00 AM
--Road-350 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--Minipump 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Paula Barreto de Mattos Laura
--Road-250 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--HL Road Rear Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Cable Lock 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Alejandro McGuel Brenda
--Long-Sleeve Logo Jersey 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Road-750 11/20/2002 9:57:00 AM 6/1/2003 12:00:00 AM
--ML Mountain Front Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Touring-Panniers 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
Garrett Young Jack
--Men's Bib-Shorts 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Short-Sleeve Classic Jersey 6/1/2003 12:00:00 AM
--HL Mountain Front Wheel 6/1/2002 12:00:00 AM 6/1/2003 12:00:00 AM
--Fender Set - Mountain 6/1/2003 12:00:00 AM
Jian Shuo Wang Cynthia
--Mountain-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--Sport-100 6/1/2001 12:00:00 AM 6/1/2003 12:00:00 AM
--LL Touring Handlebars 5/16/2005 4:34:00 PM
--All-Purpose Bike Stand 9/1/2005 12:00:00 AM
Даже няма Manager name. Какво in the name of God става тук. Нали използвате SoftUni база данни??
При създаване на модел от вече готова база при self reference (референция към същата таблица) EF ги кръщава по някаква негова си логика, аз съм прекръстил полето(както и навигационното) като "public virtual Employee Manager { get; set; }", като най-вероятно твоето поле се казва "public virtual Employee Employee1 { get; set; }".
Виж моделът, който е използван и прецени дали да промениш твоя модел или да използваш този:
https://github.com/tiapko/Introduction-to-Entity-Framework/blob/master/IntroductiontoEntityFramework/Models/Softuni/Employee.cs
а тук са всички модели:
https://github.com/tiapko/Introduction-to-Entity-Framework/tree/master/IntroductiontoEntityFramework/Models/Softuni