Question: this is my code but I keep getting this ORA-00923: FROM keyword not found where expected SELECT emp_fname as 'First Name', emp_lname as 'Last Name',

this is my code but I keep getting this

ORA-00923: FROM keyword not found where expected

SELECT emp_fname as 'First Name', emp_lname as 'Last Name', round(months_between(sysdate, emp_dob)/12,2) as'Employee Age', FROM emp

WHERE emp_mgr = 105

ORDER BY emp_dob DESC;

QUERY 1: Write and run an SQL statement to display first name, last name, and age of employees whose manager is 105. Display the results from oldest employees to youngest employees. (NOTE: In Oracle SQL, you can use the keyword SYSDATE which gives today's date.) Partial output appears below for your reference. Your screenshot should show complete query, its complete output, and your account email address. Also, please be sure that column captions are the same as below. Round any numbers to two decimal places. First Name Last Name Employee Age Rupert Washington 52.79 Jeanine Smith 50.68 Melanie Smythe 48.09

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!