下列哪个语句查出雇员表（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&rsquo