What is the longest assembly item duration for bicycles?
longest assembly item duration = max(subtract(EndDate,StartDate))
SELECT JULIANDAY(EndDate) - JULIANDAY(StartDate) FROM BillOfMaterials ORDER BY JULIANDAY(EndDate) - JULIANDAY(StartDate) DESC LIMIT 1