An SQL statement to display the departnent name and the first name and the last name of employees in upper case using a single SQL statement can be

Question

Answer

select upper(dname) from department and select upper(fname), upper(lname) from employee

Answer

select upper(dname), upper(fname), upper(lname) from employee, department on dno = dnumber

Answer

select upper(dname), upper(fname), upper(lname) from employee, department where dno = dnumber

Answer

None of these

Crowdly