[MySql] - aiuto con SELECT week

[optime]

select count(*) from tabella where date>=... and date<=...