SQL：按列的日期和范围获取数据

I have a MySQL table called 'Library' below with three columns. I need to get count of range of dwell_time for each date. The ranges I need is 0-30 , 31-60, 61-90 and 91-100.I have a MySQL table called 'Library' below wit