sql查询

平均存储流量值，单位MB/h

set @d1=(select min(updateTime) fromdaas_access_storage_files where status=6);

set @d2=sysdate();

selectsum(fileSize/(1024*1024))/hour(timediff(@d2,@d1)) fromdaas_access_storage_files where status=6;