下列哪个语句查出雇员表（employees）里的雇员名字（ename）是‘SMITH’的信息，并且给雇员名字（ename）列定义一个别名Name（）。

• A、select employeesno，ename Name，job from employees where ename=‘SMITH’
• B、select employeesno，ename ‘Name’，job from employees where ename=SMITH
• C、select employeesno，ename “Name”，job from employees where ename=‘SMITH’
• D、select employeesno，ename ‘Name’，job frome mployees wheree name=‘SMITH’