Q:

Complicated query in mysql database

I have two Tables:
**user**
  idU - autoincrement
  name

**automobile**
  idA - autoincrement
  id_user
  value
  date - type: yyyy-mm-dd

Each user has many automobile
A automobile has only one user
Currently i am using the following query for all users(5 in total):
select sum(value) as user_value, name 
from user inner join automobile on user.idU = automobile.id_user 
where name like ? AND date = ?

what i want? I want the total value of all user in specific date using 1 query. how can i do this?
@edit1:
TABLE USER
--idU------name----
   1      mateus
   2      joao
   3      maria

TABLE AUTOMOBILE
--idA---id_user----value-------date------
   1       1         250     2013-10-13
   2       3         322     2013-10-13
   3       1         150     2013-10-13
   4       3          80     2013-10-13
   5       2         100     2013-11-13
   6       3         500     2013-11-13
   7       1        1100     2013-11-13
   8       1          50     2013-12-13
   9       3         135     2013-12-13
   10      2          40     2013-12-13

I request a query with date = 2013-10-13 and it return:
---name---value
  mateus   400
   maria   422

A:

Something like:
select sum(value) as user_value, 
name inner join automobile on user.idU = automobile.id_user 
where date = ?
group by user.idU

-----------EDIT------------
select name, sum(value) as value 
from user inner join automobile on user.idU = automobile.id_user 
where date = "2013-10-13"
group by automobile.id_user

SQLFiddle here: http://sqlfiddle.com/#!2/8115c/4

