Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You want to produce a query with the following output: Employee _ ID Last _ Name First _ Name Employment _ Year Number _ Years

You want to produce a query with the following output:
Employee_ID Last_Name First_Name Employment_Year Number_Years
12345678 Smith Jody 201012
09876543 McIntyre Tyler 20192
38273652 Poindexter Nakia 20157
Which line of code provides this output?
Question 3 options:
PROC SQL;
SELECT Empoyee_ID, Last_Name, First_Name,
Employment_Year, 2022-Employment_Year;
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT Empoyee_ID, Last_Name,
First_Name, Employment_Year,
2022-Employment_Year AS Number_Years
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT Empoyee_ID, Last_Name, First_Name,
Employment_Year, 2022-Employment_Year
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT Empoyee_ID, Last_Name,
First_Name, Employment_Year,
2022-Employment_Year AS "Number_Years"
FROM EMPLIB.EMPLOYEES;
QUIT;
PROC SQL;
SELECT Empoyee_ID, Last_Name,
First_Name, Employment_Year,
2022-Employment_Year AS Number_Years;
FROM EMPLIB.EMPLOYEES;
QUIT;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

What is the preferred personality?

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago