regarding sql query

[vintaun]

my table has been creaed like this

[code=oracle]

CREATE TABLE T_GIF_PMO_ENGAG EMENT_DETAILS
(
ENG_ID NUMBER,
ENG_REQUEST_DAT E DATE,
DIV_ID NUMBER,
REG_ID NUMBER,
STAT_ID NUMBER,
CAT_ID NUMBER,
USER_ID VARCHAR2(15 BYTE),
CUSTOMER_SENT_D ATE DATE,
PROPOSAL_SUBMIT _DATE DATE,
APPROVED_DATE DATE,
GOVERNANCE_DATE DATE,
PO_NO VARCHAR2(75 BYTE),
PO_DATE DATE,
COMMENTS VARCHAR2(500 BYTE),
ENG_REQUESTOR_N AME VARCHAR2(50 BYTE),
ENG_REQUESTOR_C ONTACT VARCHAR2(200 BYTE),
BUSINESS_OVERVI EW VARCHAR2(2000 BYTE),
CUR_TYPE NUMBER,
BUS_SERVICE_ID NUMBER,
PROJECT_SIZE VARCHAR2(20 BYTE)
)

[/code]

How to write query to get the following output?
1.No.of ENGAGEMENTS less than 30 days old
2.No.of ENGAGEMENTS 30-60 days old
3.No.of ENGAGEMENTS greater than 60 days old



i guess it may be based on the second column i.e,ENG_REQUEST _DATE

[debasisdas]

Try to use the specified field and the sysdate for the desired result.

Kindly post what you have tried sofar.

[amitpatel66]

Hi Vintaun,

Welcome to TSDN!!

Please make sure you follow POSTING GUIDELINES when ever you post in this forum

Thanks
MODERATOR