SELECT col1, count(col1)/total
FROM table1 ,(SELECT count(*) as total from table1
WHERE date between '2015-08-03' and '2015-08-04'
 ) as temp
WHERE date between '2015-08-03' and '2015-08-04'
GROUP BY col1
HAVING count(col1)>1