Below is the Create table script, and insert

CREATE TABLE Rev

(

PrjDate Datetime,

PRJ_ID varchar(7),

AMOUNT decimal(26,2)

)

INSERT INTO Rev

SELECT '2012-01-31', '1', 1000

UNION ALL

SELECT '2012-02-29', '1', 1500

UNION ALL

SELECT '2012-04-30', '1', 1800

UNION ALL

SELECT '2012-07-31', '1', 1200

UNION ALL

SELECT '2012-01-31', '2', 500

UNION ALL

SELECT '2012-04-30', '2', 1000