6.查询公司中入职超过10000天的员工姓氏、入职时间、入职天数 SELECT last_name,hire_date,DATEDIFF(CURDATE(),hire_date) "worked_days" FROM employees where worked_days >10000 出错!!!!!原因:Unknown column 'worked_days' in 'where clause'【worked_days只是一个别名,而不是列名】