SQL for generate file archive data for specific date

Hi,

May I have a SQL for generate file archive server for follow items:

1.specific archive date (eg: 2014-aug-01 to 2020-aug-01)

2.number of archive file

3. total file size

thanks