I want to get data for the dates between 2015-05-01 and 2015-06-01 using SQL.
Please help me with the query.

The query I used is:

```
select *,count(id) as multiple_visitors 
    from table1 
    where id=123 
        and (date(server_time) between (CURDATE() - INTERVAL 31 DAY) AND CURDATE()) 
    group by user_id having count(id)>1 

```