Mysql query problem

Question

I have tables:

 users
    with the fields id, premium
 votes
    with the fields userid, date.

How do I select ALL THE VOTES from ALL USERS FROM TODAY only when premium = 'yes' ?

Answer 1

select * from votes v, users u 
where v.userid = u.id and u.premium = 'yes' 
      and v.date = today()

Answer 2

Use:

SELECT COUNT(*)
  FROM VOTES v 
  JOIN USERS u ON u.id = v.userid
              AND u.premium = 'yes'
 WHERE v.date = CURRENT_DATE()

Answer 3

SELECT votes.* FROM users, votes WHERE users.Id = votes.userid WHERE premium='yes' AND date=DATE(NOW())

Answer 4

select count(a.id) from users a, votes b where a.id=b.userid and a.premium='yes' and b.date=CURDATE()