how to calculate value while writing query

See more:

SQL

using this following query i am getting this below data
SELECT item,revenue,date,qty,amount FROM entry WHERE (date BETWEEN '2012-03-24' AND '2012-03-25')
ITEM QTY REVENUE AMOUNT DATE
item1 10 10 100 2012-03-24
item2 10 10 100 2012-03-24
item3 10 10 100 2012-03-24
item4 10 10 100 2012-03-25
item1 10 10 100 2012-03-25
item2 10 10 100 2012-03-25
item3 10 10 100 2012-03-25
item4 10 10 100 2012-03-25

But i want to get like the following way.
Can anyone suggets me what's the SQL query to get data this way?
ITEM QTY REVENUE AMOUNT
item1 20 10 200
item2 20 10 200
item3 20 10 200
item4 20 10 200