Problem with SQL statement

Hello,         

I have a table WORK_DONE with 4 columns(ID,START_DATE,END_DATE,WORK) with the following
datatypes.

  ID number,START_DATE date,END_DATE date,WORK number...

The table contains the following data

   ID START_DATE END_DATE WORK   100 01-FEB-03 01-FEB-03 5     106 03-FEB-03 04-FEB-03 8   101 10-FEB-03 14-FEB-03 6   103 04-FEB-03 04-FEB-03 2      110 12-FEB-03 13-FEB-03 2 What the data actually means :

 DATE WORK  01-FEB-03 5  03-FEB-03 8  04-FEB-03 8+2  10-FEB-03 6  11-FEB-03 6  12-FEB-03 6+2  13-FEB-03 6+2  14-FEB-03 6 I need to wite queries with the given data structure and data :

1. To find out work on a particular date say on 11-FEB-03...
2. To find out work on a particular date range, say between 05-FEB-03 and 12-FEB-03...

 IMPORTANT : Solution needs to be developed in SQL(not PL/SQL)

Thanx,

Pinaki Received on Mon Aug 04 2003 - 01:59:51 CDT