Name: REQUEST
NAME DATA TYPE
TASK_ID VARCHAR (6)
CUSTOMER_ID VARCHAR (10)
ACTION_TYPE VARCHAR (10)
CUSTOMER_STATUS VARCHAR (10)
NOTES STRING
CREATED_ON TIMESTAMP(6)
LOGIN VARCHAR (10)
ACTION_DATE TIMESTAMP(6)
LAST_UPDATED_DATE TIMESTAMP(6)
Name: REQUEST_INFO
**NAME **DATA TYPE****
TASK_ID VARCHAR(6)
FIRST NAME VARCHAR(20)
LAST NAME VARCHAR(20)
ADDRESS VARCHAR (256)
MATCH_TYPE STRING
CREATED_ON TIMESTAMP(6)
CREATED_BY VARCHAR(20)
LAST_UPDATED_BY VARCHAR(20)
LAST_UPDATED_DATE VARCHAR(20)
QUESTION:
Write a query to get the below data for the date range between 1-Mar-2015 to 30-Mar-2015 and sorted by CREATED_ON date in the descending order (use tables above).
• TASK_ID
• CUSTOMER_ID
• CUSTOMER_STATUS
• FIRST NAME
• LAST NAME
• ADDRESS
• MATCH_TYPE
• CREATION DATE
It looks like you're new here. If you want to get involved, click one of these buttons!
Comments
Capitalise column/table names if needed.