Merlin 🤖

Hi Lads Have been getting an error on the AdventureWorks DB, I would be eternally grateful for some help, any help at all. thank you! /* Q13 Schema(s) involved: [HumanResources] Question: Remove all shifts from [HumanResources].Shift except for Day,Evening,Night if they exist. */--------------------------------------------------------------------------------------------------- IF EXISTS(SELECT Name FROM HumanResources.Shift WHERE Name in('Day','Evening','Night')) DELETE from HumanResources.Shift WHERE Name in('Day','Evening','Night') ---- I get the below error message: The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeDepartmentHistory_Shift_ShiftID". The conflict occurred in database "AdventureWorks", table "HumanResources.EmployeeDepartmentHistory", column 'ShiftID'. The statement has been terminated.