Write the SQL code to determine which customers have placed more than 6 orders for any kind of product type 'flooring' in the past 3 years who have also had a job type 'Foundation Re-Build' in the past 2 years with employee Jordan Bailey having participated.
CUSTOMER_TYPE PK CustTypeID LEVEL PK LevelID SKILL SkilllDh auPK PK SKILL_TYPE SkillTypeID PK CustTypeName CustTypeDescr LevelName LevelDescr EMPLOYEE SKILL HOA" POH- PK Emp SkilllD FK1 SkillTypeID SkillName SkillDescr SkillTypeName SkillTypeDescr FK1 EmplD FK2 SkillID FK3 LevellD EMPLOYEE PK Emplo CUSTOMER CustID JOB_TYPE Job TypeID EMPLOYEE_POSITION PK,FK1 EmplD PK,FK2 PositionID PK PK HD EmpFname EmpLname EmpBirth Date FK1 Job TypeName Job TypeDescr BeginDate EndDate CustTypeID CustFname CustLname CustAddress CustCity Cust State CustZip POH CUST_JOB_TASK PK JobTaskID JOB JobID TASK TaskID POSITION PositionID PK PK Posit PK FK1 FK2 -- - ORDER FK3 TaskName TaskDecsr PK FK4 FK5 Position Name Position Descr OrderID TaskID EquipID ToolID EmpSkillID JobID BeginTime EndTime JobName JobBeginDate JobEndDate FK1 Job TypelD FK2 CustID Job Descr FK1 JobID Order Date EQUIPMENT LINE ITEM PK LineItemID TOOL_TYPE ToolTypeID TOOL ToollD EQUIPMENT_TYPE PK EquipTypeID PK PK PK EquipID HOA --H FK1 FK1 OrderID FK2 ProductID Qty ToolTypeName ToolTypeDescr ToolName ToolTypeID ToolDescr Equip TypeName Equip TypeDescr FK1 Equip TypeID EquipName Equip Decsr PRODUCT ProductID PRODUCT_TYPE Product TypeID TOOL_CONDITION PK ToolConditionID CONDITION ConditionID PK PK PK DO--------- Condition Name ConditionDescr ProductName Price FK1 Product TypeID ProductTypeName Product TypeDescr FK1 Toolid FK2 ConditionID Begin Date CUSTOMER_TYPE PK CustTypeID LEVEL PK LevelID SKILL SkilllDh auPK PK SKILL_TYPE SkillTypeID PK CustTypeName CustTypeDescr LevelName LevelDescr EMPLOYEE SKILL HOA" POH- PK Emp SkilllD FK1 SkillTypeID SkillName SkillDescr SkillTypeName SkillTypeDescr FK1 EmplD FK2 SkillID FK3 LevellD EMPLOYEE PK Emplo CUSTOMER CustID JOB_TYPE Job TypeID EMPLOYEE_POSITION PK,FK1 EmplD PK,FK2 PositionID PK PK HD EmpFname EmpLname EmpBirth Date FK1 Job TypeName Job TypeDescr BeginDate EndDate CustTypeID CustFname CustLname CustAddress CustCity Cust State CustZip POH CUST_JOB_TASK PK JobTaskID JOB JobID TASK TaskID POSITION PositionID PK PK Posit PK FK1 FK2 -- - ORDER FK3 TaskName TaskDecsr PK FK4 FK5 Position Name Position Descr OrderID TaskID EquipID ToolID EmpSkillID JobID BeginTime EndTime JobName JobBeginDate JobEndDate FK1 Job TypelD FK2 CustID Job Descr FK1 JobID Order Date EQUIPMENT LINE ITEM PK LineItemID TOOL_TYPE ToolTypeID TOOL ToollD EQUIPMENT_TYPE PK EquipTypeID PK PK PK EquipID HOA --H FK1 FK1 OrderID FK2 ProductID Qty ToolTypeName ToolTypeDescr ToolName ToolTypeID ToolDescr Equip TypeName Equip TypeDescr FK1 Equip TypeID EquipName Equip Decsr PRODUCT ProductID PRODUCT_TYPE Product TypeID TOOL_CONDITION PK ToolConditionID CONDITION ConditionID PK PK PK DO--------- Condition Name ConditionDescr ProductName Price FK1 Product TypeID ProductTypeName Product TypeDescr FK1 Toolid FK2 ConditionID Begin Date
