create view ElencoDateEstratte as SELECT YEAR(STR_TO_DATE(`DataAssunzione`, "%m/%d/%Y")) As DataEstratta, `Ditta` FROM `tb_assunzione` ORDER BY DataEstratta ASC


Select * FROM ElencoDateEstratte WHERE DataEstratta = 1981 LIMIT 1