create view...a simple question

[ancutza]

hi there

I have this table
CREATE TABLE `sample`.`user_production` (
`user_id` INT NOT NULL ,
`1hour` INT NOT NULL ,
`2hour` INT NOT NULL ,
`3hour` INT NOT NULL ,
`4hour` INT NOT NULL ,
`day` DATE NOT NULL,
INDEX ( `user_id` )
)

so...every user work and makes a number of products in each hour.
I need to create a view which keeps(sum) the production per hour of all the users grouped by day.

[r937]

before you create the view, can you create a query that does what you want?