按周，天，月分组查询

--按周
select DATE_FORMAT(f.upload_time,'%Y%u') weeks,
        count(*),sum(p.download_times),
        sum(p.collection_times),
        sum(p.click_times)    
from file_base f 
      left join file_property p on f.property_id = p.id group by weeks;
     
     
--按天 
select DATE_FORMAT(f.upload_time,'%Y-%m-%d') days,
        count(*),sum(p.download_times),
        sum(p.collection_times),
        sum(p.click_times)
from file_base f 
      left join file_property p on f.property_id = p.id  group by days;
      
      
--按月 
select DATE_FORMAT(f.upload_time,'%Y%m') months,
        count(*),sum(p.download_times),
        sum(p.collection_times),
        sum(p.click_times) 
from file_base f 
      left join file_property p on f.property_id = p.id   group by months;