SQL Queries working with dates

Question

Write a query that will list the employee number, employee last name, employee first name, employee hire date, a computation of the number of years since the employee was hired up to the date you run the query and the query run date. List the computed number of years as YEARS EMPLOYED and the query run date as QUERY DATE.

what I am doing wrong here? Please help

SELECT EMP_NUM,EMP_LNAME,EMP_FNAME,EMP_HIREDATE,QUERY_RUNDATE= '07/28/2011'- EMP_HIREDATE,SUM(EMP_YEARS) AS YEARS_WORKED

FROM EMPLOYEE

GROUP BY EMP_YEARS

Answer 1

First, think about what the "QUERY DATE" column should be. The way to get the date that the query is run might be slightly different depending on what kind of SQL server you are using.

Second, think about how you need to compute the "YEARS EMPLOYED" column. The instructions do not refer to a field called EMP_YEARS. You need to compute the difference between the EMP_HIREDATE and the "QUERY DATE" and express it in terms of years. Look in the SQL documentation for a function that does this computation.

Answer 2

SELECT

EMP_NUM,

EMP_LNAME,

EMP_FNAME,

EMP_HIREDATE,

QUERY_RUNDATE = TODAY()

EMP_HIREDATE,

YEARS_WORKED = DATEDIFF('year', TODAY(), EMP_HIREDATE)

FROM EMPLOYEE

GROUP BY

EMP_HIREDATE,

EMP_NUM,

EMP_LNAME,

EMP_FNAME,

EMP_HIREDATE

All non-aggregated columns from the SELECT statement need to be in the GROUP BY